Go to first empty record

[westcoastbmx]

If I am in a form and would like for it to automatically open to the first record that has an empty value.

e.g. I have 100 records with a column called status. If there is nothing in status I want the form to open up to the first empty field so I can put a status in it.

[westcoastbmx]

Ok I got it. I put (Is Null) in Status so it shows everything that needs to be added to..

[RuralGuy]

Do you care to share your solution with the rest of the readers of this forum? Do you want to follow the link in my sig and use the thread tool to mark this thread Solved?