If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Opening Forms based on Combo Box Selection (Access 2007)
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] |
Thread Tools | |
Display Modes | |
|
|