Need Help

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

OK. I need a macro, I think, when I click on it on a form
from a button I want it to run a query and transfer data
from one field of the query to my form. How is this
possible. Please reply asap coz me assignments in very
soon. lol
 
Hello Paul,

You need to use Dfunction, like: DLookup()

OnClick event for the button:
YouForm.YourField = DLookup
("FieldName","QueryOrTableName", "WhereStatement")
 
Back
Top