S
Spencer Hutton
I have a table with all of my main data in it, and another with all of the
community names in it. one of the fields is community. i have a query set
up including all of the fields from this table. in the community portion of
this query, the criteria is set to "[Combo42].[AfterUpdate]" where Combo42
is a combobox in a form with all of the communities in it from the
"communities" table. the rest of the data in this form comes from the
query. i want the user to be able to cycle through the records in the form,
only in the community shown in the combobox. so the user can choose the
community and then have the first record in the query from that community
show up, and cycle through all that communities data. my problem is when
you open the form, it prompts for the value of the combobox to run the
query. can anyone help me with the best way to accomplish this task? TIA,
Access newbie.
community names in it. one of the fields is community. i have a query set
up including all of the fields from this table. in the community portion of
this query, the criteria is set to "[Combo42].[AfterUpdate]" where Combo42
is a combobox in a form with all of the communities in it from the
"communities" table. the rest of the data in this form comes from the
query. i want the user to be able to cycle through the records in the form,
only in the community shown in the combobox. so the user can choose the
community and then have the first record in the query from that community
show up, and cycle through all that communities data. my problem is when
you open the form, it prompts for the value of the combobox to run the
query. can anyone help me with the best way to accomplish this task? TIA,
Access newbie.