Opening Forms based on Combo Box Selection (Access 2007)

I am creating a database in which people in 10 different regions will
enter information into forms for facilities in their respective
regions.

I'd like the users to open the database, select their region from a
combo box and click an "open form" command button that will open all
the records/forms in their region (right now, the forms only have the
facility name and address information entered).

How do I link the command button function to the combo box?

I know their is probably a simple answer to this question. Any help
would be appreciated!

Thank you!
Mary

On Tue, 16 Feb 2010 11:28:23 -0800 (PST), Mary
wrote:

I am creating a database in which people in 10 different regions will
enter information into forms for facilities in their respective
regions.

I'd like the users to open the database, select their region from a
combo box and click an "open form" command button that will open all
the records/forms in their region (right now, the forms only have the
facility name and address information entered).

How do I link the command button function to the combo box?

I know their is probably a simple answer to this question. Any help
would be appreciated!

Thank you!
Mary

First question... are you trying to use Access across a WAN (wide area
network)? It's not really designed to do so!

Secondly: data is, of course, not stored in forms but in Tables. What are your
tables, how are they related, and what are the Recordsource properties of your
forms?
--

John W. Vinson [MVP]