search

F

flow23

I want some help on these...
need a search box on the main switchboard.
(Text box for user input)
and three option buttons (for last name, post code, contact ID)

User inputs text in text box, and ticks one of the option button and clicks
search....

How do I do that?
 
K

KARL DEWEY

I would not put this on the switchboard but a form opened from the switchboard.
You will also need an eveent or macro to run when one of the option buttons
is selected ( do not have option group default to anything).
In the query add a field like --
OPT: [Forms]![YourForm]![YourFrameNumber]
Enter in the first criteria row 1
in the second row 2
in the third row 3

In the first criteria row and below the last name field enter --
Like [Forms]![YourForm]![YourTextBox] & "*"

In the second criteria row and below the post codefield enter --
Like [Forms]![YourForm]![YourTextBox] & "*"

In the third criteria row and below the contact IDfield enter --
Like [Forms]![YourForm]![YourTextBox] & "*"
 
Top