Searching for a record (parameter query from a form)

[Jonnagc]

How can i do a parameter query from a form, that will return the
results in a form???

Cheers,
Jg

 

[Arvin Meyer [MVP]]

Use a form reference in the query, typically, a combobox on the form. The
query would look something like:

SELECT DISTINCT *
FROM qryOwners
WHERE (((Street)=[Forms]![frmOwners]![cboFindStreet]));