TextboxA = TextboxB

What are the textbox/controls called?
How/when do you want to copy it - via a button click?

See table structure attached.
In a form based on the JobInvoiceT I am creating a new record, and I use a combobox to find the aircraft registration (ACRegoID from ACRegisterT) I want, then I use dlookup in an unbound text box (TBCustID) to find a the CustomerID for that aircraft registration.
=DLookUp("[CustomerID]","[CustomerT]","[ACRegoID]=" & Forms![JobInvADDJobbyRegoF]!ACRegoID)
I need to record that specific CustomerID on that day (from ACRegisterT) not the one in the CustomerT, onto the form JobInvADDJobbyRegoF so that it updates the JobInvoiceT CustomerID.
I then use the CustomeID in the form to Dlookup the customer name etc from the Customer Table.

I might not be doing this quite the correct way, but I need to do this because customers buy and sell aircraft, and I want to retain the original owners details against the work carried out on that particular day.

After update of combo box selection would be the best.

Just a thought,
In the ACRegister combobox Query CustomerID is the third and unused field of the combobox. Can we extrapolate that data out from the selected ACRego and put that into the Form JobInvADDJobbyRegoF CustomerID?

ACRegisterCombo.Column(#)

Hi Alex,
Can you give an example of how that would be used, is it [TextboxA]=ACRegisterCombo.Column (3), and how should I use it? do I use this as a macro in the after update field of the combobox?

Thanks
Dave

Put that code in whatever event you want to trigger the copy: the AfterUpdate event of a field, the OnOpen event of the form, etc.

Watch Intro to VBA first.