Adding multiple records in subform

[randolphoralph]

I have one Table titled Audits.

From this one Table I have created two forms Audit (main) and SubAudit (Sub).

Main Form-field names are Unique ID and Date.


Sub Form-field names are Call Date Correct, Correct Part, and Correct Description.

On the main form I have a command button that opens the subform to enter records.

The problem I am having is that when I enter multiple records under the subform it is not entering the Unique ID and Date for all the records entered in the subform...

Here is what I am trying to accomplish if the Unique ID is 106 and the Date is 12/2/2008 and I click the command button to open the subform and enter 4 records I want the underlying table to reflect Unique ID 106 and Date 12/2/2008.

[maximus]

the problem is that both the main form and the sub form has the same table as the record source. this is what is probably happening:

You make an entry in the main form ID generated is 106. When you click the command button and enter 4 entries in the subform the have IDs 107, 108,109, 110. And more over for these four IDs the Field you have Filled up the values for in the main table does not show.

The solution that I would like to suggest is splitting the table in to two tables one containing the Fields that you will fill up in the Main form and the other containing the fields that you want in your subform. Check out Relationships and Subforms. I think thats what you need.