query to open form?

[jgraves]

Can I use a query to open a form?

I have 2 different companies I enter data for. I want to set button on my switchboard that when clicked asks which company I am entering data for. Then it opens the form for that company.

If I say "company 35" then it opens the form for "company 35".

[PEB]

You need to enter as On click event procedure of the respective bouton:

Docmd.openform "Yourformna me"


:)