Prev: Counter
Next: Fiscal Six-Month Periods
From: Mary on 16 Feb 2010 14:28
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
From: John W. Vinson on 16 Feb 2010 16:27
On Tue, 16 Feb 2010 11:28:23 -0800 (PST), Mary <maryfaithjames(a)gmail.com>
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]
 | 
Pages: 1
Prev: Counter
Next: Fiscal Six-Month Periods