how do I query a form to do the next step

[f_disk]

I have a switchboard and when I click a certain button ...
it opens a prompt popup.

In the popup you enter the required "item" and you hit enter or "ok"

It then does a search for the specified "item" and brings up
that information.
At that time I would like to have a calculator
pop up for the user to use.
(newb) How in laymans terms do I get this to work ?

In my "forms" Design View I have:
Switchboard and Calculator

In my "Queries" I have query 1

In the tables section I have :
Sheet one (this is were the query is getting its search info from.
Switchboard items

Is there something I can add to my query to get it to open the calculator form ? Or is there some other way without using additional buttons to do this.

 

[MStef]

Hello f_disk!

As I can understand you, you need something like
"DemoCalculatorA2000.mdb".
Open Form1.

 

[f_disk]

Big Thanks MStef !!

I took a look at your code and modified it a little
and was able to get my calculator to work the
way I was looking for....
Your help is greatly appreciated !!
Nice Job !!

I'm new at Access and have only been on it for
about two days and I love it ....