View Full Version : Error Checking for EOF / BOF Debug

03-09-2009, 03:14 AM
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?


Bob Phillips
03-09-2009, 03:21 AM
Just create a query to read it first, if you get EOF on that recordset, it doesn't exist.