Populate form with current record

[drew17]

Hi, I'm new to access and I'm having trouble setting up my forms.

I have tables for "owners" (this is basically just a weird name for customers) and for "jobs". The related fields between the two tables are called "OwnerID". I have specific numbers (not autonumbers) for both OwnerID and Job#. I have created forms for both of these tables.

I want users to be able to enter in a new owner or find an existing one, using the owner form, and then to hit a command button to open the "job" form to be able to enter information for that specific customer. I have tried using the command button wizard to open a form to a specific set of data and I set the two related fields (OwnerID) as references for the button. However, when the button is clicked, the Job form opens up to a new record but does not populate the OwnerID field.

How can I fix this?

Thank you for your help

[burrina]

You should have that on your Main form and use a Combo box with a Lookup. 2 fields, 1 for the lookup, 1 for a New Record. is all you need.

HTH