Access Form record count differs from Table record count
Posted on 2011-05-03
I have a DB with a table called ‘TestBooking’ to which I have a query called ‘TestBooking Query’
I have a form with the RecordSource as ‘TestBooking Query’
For test purposes I have entered some values into a field called [Works Order No].
(4 records as follows:- “79804”, “79805”, “79806”, “79807”)
I want to the user to enter a number (as string) onto my form.
Then the system finds the record and then the record can be displayed/edited.
The form only shows ‘records 1 of 1’ whereas the DB (& therefore query) has 4 records.
This means that if I use the built-in ‘find’ it cannot find any records.
(even the < or > buttons are grayed).
I have also written some VBA event code to find a string within [Works Order No] and even this can’t find any records.
I am fairly new to Access so I must be doing something wrong.
Can anybody help?