Originally Posted by Badvoc
15945 total records in table, the form gets its data from a query of the SQL table
You did not answer the question.?
So if the DrawingNo is unique and you open the form for a particular DrawingNo how many records do you expect to see?
If I create a form on a table and issue
I get one record as the ID is unique.? If I did it on ClientNo I would get 28 records.?
You are in effect setting a filter for a subset of records.
Indeed with my ID option, if I toggle the filter I get all the records again.?