Filtering Form from Single Field

[shaybob1711]

Hello All,

I have an issue I cant seem to figure out. I have a table that stores all info for specific jobs going through our assembly dept and I need to have 2 seperate forms to fill out specific infomation about the jobs. (Main entry form for basic job info, and Job progress form to fill out dates like day released, ship date as they happen). I have created both forms successfully but in the job progress I need to be able to pull down an existing Job Number (Primary Key for tblJobInformation), filter the related info into the other fields in the form (3 out of 10 fields in the table), and be able to update the fields for that primary key. Remember everything is running off the same table. I'm sure I'm over thinking this but any help would be appriciated. Thanks.

 

[matthewnsarah07]

You could simply add a basic search form to your database to filter the data you need.

Add a form say frmsearch and put an unbound field on it say called [jobnumber] - then create a button on the form and use the wizard to open your progress form with the to Job Numbers fields linked.

To make your system even easier why not make the progress form a subform on the basic details form so everything is displayed in one place?

Hope this helps