Jumat, 08 Juli 2011

[MS_AccessPros] Use both buttons and combo box to open a Forms.

 

Hello there!

I'm using Access 2007, and I have the following forms:

F1 - A form that has an analysis for TYPE A institutions for each State.
F2 - A form that has an analysis for TYPE B institutions for each State in the Country.
Main Menu - A form that is by default the form that opens up when I open this database.

Let's say States are STATE1, STATE2, and so on.

So my objective is the following:

In the Main Menu, I have 2 buttons that alternate (you can only choose 1 option of those 2, the options being TYPE A and TYPE B) and a Combo Box (That displays the name of the States: STATE1, STATE2, ..., STATEn).

So I want that, when you choose, for example, TYPE A and then choosing from the Combo Box a State -say, STATE1, for example- it opens F1 in the STATE1 Record.
If I choose TYPE B, and STATE10 afterwards, it opens F2 in the STATE10 Record.

I have a combo box that opens F1 in the State I choose... but I don't know how to tell it to open F2 or F1 depending on the Value of the buttons that alternate. Is that possible? Or is there any way of doing this another way?

I appreciate the help.
Thank you for your time and have a great day!

Cesar

__._,_.___
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar