how do I query a form ?

f_disk

Registered User.
Local time
Today, 07:56
Joined
Jul 18, 2006
Messages
45
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.
 
1) You can't query a form. Form contains no data whatsoever. You can query a table or query which a form is based on.

2) I'd avoid using spaces in object names. This can bite you in rear later on.

3) I believe the Sample Database forum has a Calculator form. Search there; or google for it. There should be enough samples for you to download and modify to your database.

HTH.
 

Users who are viewing this thread

Back
Top Bottom