syntax for picking a record on a form in a query

Lanason

Registered User.
Local time
Today, 16:15
Joined
Sep 12, 2003
Messages
258
I need to print a particular selected record from a form which contains a list. The query has the correct field, but I cant remember the syntax. I think is something like "me.forms!me.Fileld1".
can anyone help and put me put my misery . . . thanks
 
if the code is on the form itself:
me.fieldname

if the code is not on the form:
forms!formname!fieldname
 
if the code is on the form itself:
me.fieldname

if the code is not on the form:
forms!formname!fieldname

the code is in the query . . . as a selection. A want to use the value on the current form to select in the query
 

Users who are viewing this thread

Back
Top Bottom