Forum Discussion
SQL query returning EOF
Editing a state data field. Hitting a table called "States". If i get a hit then data entry is good otherwise invalid entry. So only needs to return one record. When i hardcode the state ""KS"" i...
you can use DAO.Recordset also.
your current query will not include Null (empty) for [State Abbreviation] Or [State].
always test for both .BOF And .EOF.
arnel_gp Thanks for your response! I will convert this to DAO and see if it handles the query better. Will also check for both EOF and BOF. I hope this helps. I will be a couple days before i can get back to this. I will respond again. Again, thanks.
