Adding Input to DLookUp expression

T

Tim

I am using a DLookUp filed on a form and want to prompt a
user to change the value in certain circumstances. Is
there a way of adding an Inupt Box to a DLookUp expression
as below:

=IIf([Field1]=1,ASK THE QUESTION,DLookUp
("[Name]","table","
Code:
=" & [Field1]))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top