Copying fields in one form to another...

[katie george]

Hi - I am having troubles copying data from one form to another..

I have two tables customer and vehicle, the primary key in the customer table is CUSTOMER_ID (autonumber, long integer, indexed with no duplicates) this is the foreign key in the vehicle table CUSTOMER_ID (long integer, general number, indexed, duplicates ok).

When the user has entered the customer details in form CUSTOMER they click on a save button which gives them the option to add vehicle details. The VEHICLE form opens with a blank record.

I have been trying to get the CUSTOMER_ID in CUSTOMER to be copied into the CUSTOMER_ID field in VEHICLE when the form opens using the following code..

DoCmd.OpenForm "VEHICLE",OpenArgs:=CUSTOMER_ID

then in the Form_Open procedure of the form VEHICLE:

Private Sub Form_Open(Cancel as Integer)

CUSTOMER_ID = OpenArgs

End Sub

This works if the CUSTOMER_ID field in VEHICLE is unbound but not when its control property is CUSTOMER_ID, so therefore does not update the VEHICLE table with the value copied just leaves it blank. Having fiddled around for ages is there anyway of copying this value into the CUSTOMER_ID field and underlying table?

Any help is much appreciated

Thanx

 

[ColinEssex]

Make sure the Customer form is still open or minimised when you open the vehicle form.

In the OnCurrent event of the vehicle form put

Me.Customer_ID = Forms!Customer!Customer_ID

Col

 

[katie george]

Thanx Col that worked perfectly!

 

[ColinEssex]

Thanx Col that worked perfectly!

You're welcome