Appending data

[KLewisBPM]

I have a table called prod with the following fields

Date
Order_No
Customer_ID
Shift
MC_Spd
Output
Run_time
Comments

I would like to add a button to the Prod form that will open a data sheet with 2 columns

Cause
DT_Mins

I want to end up with records in another table that shows

Date
Order_No
Customer_ID
Shift
Cause
DT_mins


When I enter a Cause and DT_mins the rest of the fields should just populate based on the info on the open form.

I hope this is clear enough?


Kind Regards

Kelley Lewis

 

[Remou]

Are you talking about a form and sub form? It is possible to have more than one link child and master fields, these will be automatically populated from the main form in a new record.

 

[KLewisBPM]

I'm talking about 2 different forms, I open the second form from the first form in datasheet view only showing 2 columns, Cause and DT_Mins as type in Cause it creates a new record in the table however I want it to populate some other fields in that table from the first form.

Kind Regards

Kelley Lewis

 

[Remou]

I would say the best bet is an update query run from the second form. Alternatively, you could open the table you wish to populate as a recordset.