Open form and auto enter data

[axw]

So, I've got a frmCustomer and want to link the form to frmNewWorkOrder using a button.
More precisely when I choose/scroll to a customer and click the button "New work order" to autofill data from selected client from frmCustomerto frmNewWorkOrder (First and Last name, telephone number and client ID)
What code do I use to achieve this?

 

[bob fitz]

I don't think you should be doing that because that would be duplicating data (First and Last name, telephone number) in another table. It sound to me as though what you have is a one to many relationship between the tables/queries that the forms are bound to, in which case the correct way would be to have a main form with a subform control. The Foreign Key value of the table/query that the subform is bound to would then be populated automatically by Access when a new record is created.

 

[axw]

Thanks a lot, It did cross my mind but since I'm fairly new to the whole "access experience" I'm still struggling with the basic database organization.
Once again, thank you very much.