how do i allow user to choose search type 1

[TABLOW]

I have a query that brings up a form based either on an issn search or a keyword title search. How do I allow the user to choose which search type they would like to use? Right now I have to text boxes and two command buttons, I would like to reduce this to one text box and one command button. Any help would be appreciated.

low

 

[ajdesalvo]

here is one way;

Place one text box and one command button.

In the command button Click event:

If MsgBox("Press Yes to Search by issn, Press No to search by Keyword.", vbYesNoCancel, "Select Search Choice.&quot = vbYes Then
MsgBox "Search by issn"
ElseIf MsgBox() = vbNo Then
MsgBox "Search by Keyword"
End If

Hope this helped!

Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"