How can i do a parameter query from a form, that will return the results in a form??? Cheers, Jg
J Jonnagc Oct 6, 2008 #1 How can i do a parameter query from a form, that will return the results in a form??? Cheers, Jg
A Arvin Meyer [MVP] Oct 6, 2008 #2 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]));
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]));
