Importing Data from another Form

[A|ex]

Hi i was wondering if anyone can help, ive got a sales form and a add customer button, how would i insert all the customer information inputted in this other form to my current sales form?i understand i could provide a lookup based on whatever customer id the user inputted but i prefer to do a simple insert rather than flicking back to the add customer and finding the customer details.

Regards

 

[doran_doran]

agrs

Hi,

you can use agrs to pass values from forms to forms.

Good luck

 

[A|ex]

how would i do that, if i was programming i would store the values in variables then insert the variables into whatever form. Do you have an example?

 

[Rich]

Use a combo box to select the customer

 

[A|ex]

thats the easy way i prefer to add customer detail and have them auto import, rather than add the details, remember the id then find the id in the combo box

 

[Rich]

Then it's just
Forms!Orders!CustID = Me.CustomerID

 

[A|ex]

Doesnt work it brings back the first customer record not the one entered

 

[Rich]

You have to save the newly entered record first.
DoCmd RunCommand acCmdSaveRecord