Dlookup Not Working

[nigelapt]

Hi
Any advice would be greatly appreciated.
I have two tables - tblBatchDetails and tblResources
On frmBatchDetails I want to pick the BulkCode from a combo box, do a lookup on this value and bring back the description from tblResources. The field tblBulkCode is defined as a Number.

When I add the following expression to the control source of an unbound text field on the form, nothing is displayed.

=DLookUp("[tblDescription]","tblResources","[tblBulkCode] =" & Forms!frmBatchDetails!tblBulkCode)

This is driving me mad as I have used this many times before without any problems

Thanks

Nigel

 

[TheAceMan1]

How are ya nigelapt . . . . .

Everything looks ok save the what I believe is suppose be [blue]your combobox reference:[/blue]

[blue]Forms!frmBatchDetails![purple][b]tblBulkCode[/b][/purple][/blue]

If this is indeed the combobox, try:

[blue][purple][b]Me[/b][/purple]!tblBulkCode[purple][b].Column[/b][/purple](1)[/blue]

If not, please advise . . . .

See Ya! . . . . . .