Copy from one form to another

[Adam858]

I have a Jobs form that a technician uses to look up details of a job they are working on. This form already contains a JobID and CustomerID. I want a button that the technician will click to do the following:

1 Create a new invoice using the Customer Orders form. (this I can manage lol).

2. From the Jobs form I want to take the values from CustomerID and JobID and insert them into the new record on the Customer Orders form. (this is the bit I am stuck on atm).

Thanks in advance!



Adam

[pbaldy]

From the source form, the code would be:

Forms!SecondFormName.TextboxName = Me.TextboxName

Here's a good reference:

Forms Refer to Form and Subform properties and controls

[Adam858]

Excellent, thanks paul, that was a great help, its all working now!

Cheers

Adam

[pbaldy]

Happy to help, and welcome to the site!