Parameter query - capture value and populate a form

[Yodel99]

Greetings,
I have a form (Form1) based on a parameter query (Query1). I want the
value that the user enters in the parameter window to populate a field
in the form. I've been able to use the following to capture the value
if the qry is satisfied, and put it in a column in the qry.

PARAMETERS value Text (255);
SELECT DISTINCTROW [Table1].[lastname], [value] AS Expr1
FROM Table1
WHERE (((Table1.lastn ame)=[value]));

Two issues - how do I reference Expr1 in the form, and how to I still
capture the value if the qry is not satisfied.

Thanks in advance,
Yodel99

[Brian Graham]

Don't make your form try to reference the query. Make your query reference the form value.

Put a condition on your query like
forms!form1.[fieldname]

Yodel99<ja***** @ieee.org> May 12, 2005 4:11:07 pm >>>

Greetings,
I have a form (Form1) based on a parameter query (Query1). I want the
value that the user enters in the parameter window to populate a field
in the form. I've been able to use the following to capture the value
if the qry is satisfied, and put it in a column in the qry.

PARAMETERS value Text (255);
SELECT DISTINCTROW [Table1].[lastname], [value] AS Expr1
FROM Table1
WHERE (((Table1.lastn ame)=[value]));

Two issues - how do I reference Expr1 in the form, and how to I still
capture the value if the qry is not satisfied.

Thanks in advance,
Yodel99