form to enter id and have it open that records form....can it be d

[DH010010]

hi all...

i have a db that is used to run my companys workshop but i have an area that
im stuck on. now.... reception enter all the customers details in to a form
that in turn loads the information in to other tables. i need to creat a for
that will enable our workshop to update 1 part of the customes info... and
that is where there car is in our shop. I want a form that just has one box
that you enter the ID in then on pressing enter it will open another form so
they can select the stage it is in the after that one is updates it will go
back to the first form and be blank ready for the next tech. can this be
done. i have tried a few things but it doesnt seem to work :-(

you help is greatly received.

 

[Mushroom]

I'll take a shot at it.

The way I would do this is to create an unbound form with a text box and a
button that will eventually be used to open the second form.

Create a second form, the form you are wanting, with the appropriate data to
be updated. In the second form, base it on a query. (go to properties of
the form and select record source) Open that query and in the criteria box
for your customer ID, right click and select build. Now select the first
form you created and the text box on it.

When your user inputs the ID on the first form and clicks the button, it
will reference the ID on the first form and only show you that customer's
data. Place a button on the second form to close it.