Error Checking for EOF / BOF Debug

[AndrewKent]

Hi there,

I am trying to transmit data to and from an Excel worksheet to an ".mdb" file. However if I try and recall a record from the file to excel where the primary key doesn't exist, I get a EOF BOF debug.

I want to put in an IF statement that will firstly check if the record exists in the table before it trys to return it.

How can I do this? I think I have to check if EOF BOF is true but I don't know how to write the syntax, can anyone help?

Andy

[Bob Phillips]

Just create a query to read it first, if you get EOF on that recordset, it doesn't exist.