SEARCHING USING COMBO BOXES

[philipmck]

I HAVE A FORM WITH 3 COMBO BOXES - PROCESS , OPTION1COMBO AND OPTION2 COMBO. I ALREADY HAVE IT THAT IF YOU SELECT AND OPTION IN PROCESS IN CHANGES WHAT APPEARS IN OPTION 1 ETC ETC BUT WHAT I WANT TO KNOW HOW TO DO IS HOW CAN I GET IT THAT THE "SEARCH" BUTTON WILL TAKE THE INFORMATION SELECTED FROM THE 3 COMBO BOXES AND THEN SEARCH THE DATABASE AND BRING BACK THE NECESSARY RESULTS?

 

[PHV]

Please, don't SHOUT.
What have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Remou]

Please do not use upper case, it is usually seen as 'shouting' and is not polite.

When you say 'bring back the results' what do you want to happen? Open a new form? Show only matching records in the current form or subform? And so on.

 

[philipmck]

Basically i have a database window showing in the form. At the start all of the records are showing then once a search is completed it just shows the results.

And apologies but i didnt mean to shout.

 

[Remou]

By database window, do you mean a subform? You can:

* Change the RecordSource of the subform via code.
[tt]Hint
Me.[Name of Subform Control].Form.RecordSource="SELECT ThisText, That, Etc FROM tblSomeTable WHERE ThisText LIKE '" & Me.cboThis & "*'"[/tt]
* Set a filter on the subform via code
[tt]Hint
Me.[Name of Subform Control].Form.Filter="ThisText='" & Me.cboThis & "'"
Me.[Name of Subform Control].Form.FilterOn=True[/tt]
* Set Link Child and Link Master fields either via code or in form design.

 

[philipmck]

I have the database on the form. That works perfect:

Private Sub Form_Load()
'Me.Child27 = Data
End Sub

What i need the code for is to get the SEARCH button to take 3 pieces of information from 3 combo boxes and then search the database with the selected information

ps thanks for your help

 

[Remou]

You say above:
At the start all of the records are showing then once a search is completed it just shows the results.

This is not a search, it is a filter or some other adjustment of the recordset. Have a look at filter.