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")
 
You must log in or register to reply here.

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

Similar Threads

Help Me Please 1
Please Help Me 1
Access Access Report Works on One Machine but not Another 3
Form fields don't need to always be filled in 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Access How to Validate the query parameter before loading the form that is based on the query iteself? 2
I need a Form button to open and pass two variable values to a re 2
Am I disturbing a machine in production floor if I access its database remotely? 4

Back
Top