My question is:
Can I type the Dlookup function in the ControlSource property of a text box on a form or report?
Acctually, I want to poll Price from table named "Stock",so I will have Dlookup formula that looks like this:
=DLookup("[Price]", Stock", "[ItemNumber]like" & "'" & [ItemNumber] & "'")
This formula works great in Microsoft visual basic, but when I try to type it in ControlSource
of a text box,syntax erros appears.
Any help is appreciated.