MS Access database support - Select in a field

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Select in a field

Marco DM

2006-04-05, 9:35 am

I all, i must to put a value in a textbox that's the results of a query
"select" in the code..
How can i do
Thanks

Ron2005

2006-04-05, 9:35 am

IF the results of the query is a single record which contains the
information you wanted:

In the OnCurrent event of the form

me.txtboxname = dLookup ("[XXXXX]", "MyQuery")

where XXXXXX is the field name that contains the desired information
and
MyQuery is the name of the query that returned the desired
information.

Ron

Sponsored Links