Field in Table will not populate

[4304]

My DLookUp field will not populate the field in my table or on my report. For example:

My field is called Suppliers and it looks up the Supplier Name by Supplier ID.

My table has a field called Suppliers, but the information that is "looked up" does not fill in the fields in my table, nor on my report.

 

[lespaul]

do you mean that you have a lookup field in a table?

What is the DLOOKUP formula that you are actually using?



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[4304]

No, my apologies. I have a DLookUp field in a form that populates a table. However, that field is the only field that does not show up. The formula that I have is in a text box and is as follows:

=DLookUp("[Suppliers]","[Supplier Table]","[Supplier ID]= " & """" & [Supplier ID] & """")Sort Order

 

[PHV]

If Supplier ID is defined as numeric in Supplier Table:
=DLookUp("Suppliers","[Supplier Table]","[Supplier ID]=" & Me![Supplier ID])

If Text:
=DLookUp("Suppliers","[Supplier Table]","[Supplier ID]='" & Me![Supplier ID] & "'")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dhookom]

I'm not sure why you would not add the "Supplier Table" to the report's record source so you could add the Suppliers field to the report. This would be much more efficient.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]