Query Options

  • Thread starter Thread starter Douglas @ Helpdesk
  • Start date Start date
D

Douglas @ Helpdesk

i currently use a search option by typing in "*" [Type search here] "*" into
the query. I am then able to have a popup box come up and i am able to input
information in there about a specific account.

Is there a way to still get the pop-up box but instead of being able to type
text in, that you would be able to get a drop-down list with the account
names instead and still perform the search?

Also, Is there a way to get around the limit of 8 options on a switchboard
screen?
 
Douglas

Based on your description, I suspect that the "popup" you are seeing is the
parameter prompt for a query.

If you need to present a combobox (drop-down) of selection choices, you'll
need to create a form that you "pop up", and you'll need to modify the
Selection Criterion of your query to point to that control on that form,
something like:

Forms!YourFormName!cboYourComboBoxName

As for your switchboard question, you get around it by creating your own
("Main Menu") form and placing your command buttons on that form. From a
use-ability standpoint, do your users really want to have to pick among and
click on more than 8 menu choices?

(For whatever it's worth, I stopped using the Switchboard when I decided
that I had more control over "look & feel" by creating my own main menu
forms.)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top