mutilple forms one database

[blacktide]

I spent the last hour reading post after post trying to find the info I was looking for with no luck, so I thought that I would post and see what I get.

I have one database and multiple forms. I enter data on a form when we receive a unit in and it goes into the database. This form does not complete every field in the database.

This unit is assigned a unique work order number.

Now when I ship a unit I use a different form. In this form I want to use the work order number to pull up the correct customer and fill out the rest of the information. How is this done?

I am sure that this is fairly simple, but I have not come across a way to do this.

Thanks for your help,

Mike

 

[namliam]

Welcome to the site

Try looking into
Filter options
Where clauses
and OpenArgs of the Docmd.Openform command

one of these will help you.... Which depends on you situation and your preverence...

Regards

The Mailman