Help on macro to scroll one record back?

[getholdofjoru]

I am using a form to enter data and it is linked to another table and pulls in related data for the user to reference when entering information. In detail, when they key in a ticket number, it pulls the related information from another table so they can make sure they have the right rack.



When they scroll too far ahead on the form, all of the reference fields turn blank. How do I attach a macro so when the reference fields are blank it will go back one?

Thanks!

[getholdofjoru]

And I am a basic user by the way

[is49460]

if i understand you correctly if scrolled too far it will take you to the new record, and that's why it's blank. Change the property to not allow to create new records and you wouldn't see any blanks.