[RESOLVED] if i have three buttons...

[edith]

If I have three buttons:

Red button
Blue button
Green Button

and each opens a new form, depending which button the user clicks on, data of the color will appear in a new Form Page.

Example:

The RED button has data A and B... so if I choose Red the next screen should bring me A and B button so I can choose from one of them.

The BLUE button has three options: Option 1, 2, and 3. So, if i choose one of them, then the next screen should bring me data regarding option number 1, if i choose option number 1. And so on if I keep choosing different options.

The First screen or Form Page would consist of three buttons ( RED, BLUE and GREEN ). Depending which color the user chooses then the next Form Page would bring more buttons to choose from. Until we have the result....which is
For Example:
RED A is 95%
Red B is 100%
BLUE 1 is Excellent
Blue 2 is Good
BLUE 3 is Poor

Hope someone can help me on this.

[mendhak]

What have you coded so far?

[edith]

Not really coded anything yet. I just created the a Form with the idea of what i want, becuase i cant do what i want. I am using MS Access for this, because is a simple three button Screen. The main menu has the three buttons and each button calls for another screen with more buttons.

[Lord Orwell]

you can set up multiple forms in access easily. just have each form open the next one for you. however if all the first screen does is open another screen with more buttons, you can have multiple switchboards launched from the first one. they will all use the same window and look professional.

[edith]

thanks

[edith]

lord Orwell:

How can I add more than 8 buttons to the switchboards? It only allows 8??

[Lord Orwell]

you can't. You would have to make your own form, or have sub-switchboards.

[edith]

oh, thanks.

ANOTHER QUESTION:

If I have two numbers that are constantly changing and want to give a result (this will be the third number that changes) of everytime they change on the form. What formula could I use?

Example:
I have 10 boxes in a room. And a put 5 more, I want to see the total of the boxes I now have. For every time a enter or take a box I want to see the total of boxes.

Please advice.

[Lord Orwell]

you should always create a new thread for a new question. This applies normally, but you've already marked this as resolved so most people aren't even going to look at it to see you have another question.

but you basically put a 3rd textbox on the form and it is UNBOUND!
you then type a formula in this third textbox referencing the other two boxes.
for example if box 1 was called Boxcount and box2 is called Partsperbox (for example!) the formula you would type in the third box would be (probably) this:

=[Boxcount]+[Partsperbox]

i don't have access currently installed but i think that's correct.