DLookup (Access 2000)

Topic

New Reply

In my report i have a control source with DLookup that is all right.However, when i try to put it as code in the OnOpen event of the
report,i receive the mseeage that you have entered an expression that has no value
Me![TxtQuantityOutput].RecordSource = DLookup(“Quantity”, “qryBlOutput”, “ProductID = ” & [Productid])

What may be the reason ?

Reply | Quote

Replies

Put it in the On Load event instead of in the On Open event. On Open occurs before the first records has been loaded, so ProductID is not known yet. On Load occurs when the first record is loaded.

Reply | Quote