Please Help Me

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul - 30 Dec 2003 17:44 GMT

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

Reply to this Message

Ken Snell - 30 Dec 2003 19:12 GMT

Check out the DLookup function; it's in help files. It's used to obtain a
value of a field from a single record in a table or query.

Sounds as if this is what you need. Good luck on the assignment.

Signature

Ken Snell
<MS ACCESS MVP>

> 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

Reply to this Message