Queries within a switchboard and form

Connor

Registered User.
Local time
Today, 13:59
Joined
Oct 21, 2005
Messages
18
If its possible, can i have a querie that lets the user find a specific record, say based on flight number or flight date (for an airport) right from the switchboard?,
I can do this within the main form, but ir returns the table view of the record, which i dont want, i would like the form view of it? This possible

Thanks
 
If it returns the table view, that is probably because you are opening a query rather than a form. Use the where argument of the OpenForm Method/Action to open a form to a particular record.
 
.

are there any tutorials on this site, or online regarding the "OpenForm Method/Action" , as i am a newb with these type of commands?
 
If you look up OpenForm Method and OpenForm Action in help, the entries explain the parameters.

The best method is to open an unbound form that contains combos or textboxes which gather the parameters. Then have a button on this form open the bound form. The switchboard would open the unbound form, the unbound form would gather the criteria and the button on it would be used to open the bound form to the desired record. The button wizard will build the necessary code to open the form but you will have to modify it to add the where argument.
 

Users who are viewing this thread

Back
Top Bottom