Form opening to wrong record

M

meghanwh

I have a form which is based on a query. The query sorts the records on
ID number. The form opens to someone's record who should not be first.
It's the same person every time, and the records from 2 up look to be
sorted correctly, but I do not know why it is coming up with the wrong
initial person each time. The query is fine, it sorts them perfectly.
Any ideas?
 
J

Jeff Boyce

Is there a filter or sort order set in the properties of the form?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
M

meghanwh

Jeff said:
Is there a filter or sort order set in the properties of the form?

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
No, neither a filter or a sort order on the form.
 
M

meghanwh

Jeff said:
Is there a filter or sort order set in the properties of the form?

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
No, neither a filter nor a sort order on the form
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FORM DIED - form based on query no longer opens to correct record 3
Allowing Temporary Sorting 1
Entering New Record on Subform 1
Save record sequence number from form 2
Go to specific record on form 4
Move to First Record on Sub Form 2
Error when adding a new record to a form 3
Copy record info into new form 0

Top