Hi all,
I have a form called Accounts.frm that I have approximately 20 users enter data into. Someone will go in behind each user sometime in the next week or possibly a bit longer. The 2nd person needs to verify the first person:
a. created a record for the account#
b. entered the correct data for the account#
I need the user to be able to search the tables in this form for a record and see if one for the Account# exists. I need the data entered for that account# to pull up in the form. Then once person 2 pulls up the account# record, they can edit the information if it is incorrect.
I originally thought I could just have them use the record search at the bottom of the form but it seems this function only works for data you enter during the current session.
I know this sounds easy but I'm pretty new to access and learning on the fly. I have tried Googling as well but I'm thinking there is something really easy that could allow me to do this so I figured I'd start with the experts!![]()