subform with a query as the record source

[Lori]

I am using Access 2002. I have a form based on a table named zip code. I
have a subform based on a query named Active Vendor.

A record displayed in the Zip Code form is for one zip code. Is there way
to have the query automatically run to display all vendors within the zip
code record displayed on the form?

The query is a select query that prompts the user to enter the zip code for
which records are retrieived. Currently, nothing displays on the subform,
I'm not prompted to initiate the query.

Thanks

 

[StevenR via AccessMonster.com]

I am using Access 2002. I have a form based on a table named zip code. I
have a subform based on a query named Active Vendor.

A record displayed in the Zip Code form is for one zip code. Is there way
to have the query automatically run to display all vendors within the zip
code record displayed on the form?

The query is a select query that prompts the user to enter the zip code for
which records are retrieived. Currently, nothing displays on the subform,
I'm not prompted to initiate the query.

Thanks

In order for the query to update without asking you for the parameter you can
name the control on the main form that holds the zip code the same as the
parameter in the query. This will cause the subform to requery everytime the
value in the control changes.

Parameter name: @yourparam
Control name: yourparam

HTH