Search table in form / edit data in form

[Guitarzan]

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!

[rpeare]

Base your validation form on a query that is looking for a specific account number, the easiest way to do this is to create a query and put [Enter the Account Number] in the criteria of the query. Create your validation form based on that query and put a button in the form header or form footer and in the ON CLICK event of that button put in

me.requery

Every time they click this button they'll be asked for an account number and your form will bring up all information relating to that account.

[Guitarzan]

I'm officially an idiot. I couldn't use the search at the bottom simply because I had data entry mode set to "on".

Now, the only thing I need to figure out is how to get my form to default to a new form instead of a previous record?

[rpeare]

when you open the form docmd.gotorecord acnewrec (not 100% sure of the syntax but it's something like that)