I am a very new VB programmer, and require help with the SEEK command.

When I perform a search using an index, if the value is NOT found I get a
VB error saying "No current record"

Any ideas on how to stop this annoying little mesage would be very helpful,
as I have my own error trap which follows.

Please help!

Rob Brown

Hi Rob,

The no current record is not fired when seek returns NoMatch, but when the table or
recordset is empty. So :

if TheTable.RecordCount >0 then
    TheTable.Index = "PrimaryKey" 'for example
    TheTable.Seek "=", "33" 'for example
    if Not TheTable.NoMatch then
        'you've found a record
    else
        'no record found
    end if
end if

Regards.

Christian Hugoud

: I am a very new VB programmer, and require help with the SEEK command.

: When I perform a search using an index, if the value is NOT found I get a
: VB error saying "No current record"

: Any ideas on how to stop this annoying little mesage would be very helpful,
: as I have my own error trap which follows.

I also a new VB programmer and also encounter your problem.
Are you using the "data", if yes, don't assign databasename and record
source at the design time, when I remove them, and assign them during
the running of the program, my problem is solved! Then you can use the
no match function to check the error.

K