Unbound text box

[reboot_computers]

hi iam having a problem trying to use an unbound text box on a form in access 2007. I am trying to pull the first name out of a table called customer where the id matches the same customer id used on the form(Frm_jobs using this code =DLookUp("FirstName","Customer","CustomerID=" & [Forms]![Frm_Jobs]![CustomerID])and all I get is error in the text box, can anyone help please.

Thanks

 

[burrina]

Try this:

If Me.newrecord Then Me.txtcustomer = ""
Me.txtcustomer = DLookup("[FirstName]", "Customer", "CustomerID=" & Me.CustomerID)

HTH

 

[reboot_computers]

That's great, thank you