Problem with DLookup on a Form

[julesinbath]

I have a form that displays all the details of a Job. Most of the text boxes use data from an underlying query that selects all the job details. But I want one of the text boxes to select the "Customer call off number" from the Customers table.

The jobs and customers tables are related by customer_Id. that is, every job has a customer_ID. I have tried selecting the CustomerCallOff via the underlying query, but it results in the form being unable to update the record.

So, I am trying to select the CustomerCallOff from a seperate query using the DLookup function:
DLookUp([CallOff],[queryCallOff])

...but it doesn't work. Instead the textbox displays "#Name?"

Can anyone shed some light on this issue?
Jules

 

[SuicidED]

Hi, I think your syntax is wrong, try this
=DLookUp("[CallOff]","queryCallOff&quot

 

[julesinbath]

Thank you VERY much!

Jules