Multiple Entries to Search

[GiovanniB]

Hi,

How can I have for one command button to open a form by searching for data in two or more text boxes or fields from one main combo box?

Here's what I am facing for instance:

stLinkCriteria = "[Color]=" & "'" & Me![Combocolors] & "'"

Is there a way were I can add [color2], [color3], etc to the above code ?

I thank anyone who can help me find a solution to this predicament.

Thanks a bunch,

Gio

 

[jebry]

Hi Gio!

See the following code for multiple text boxes:

stLinkCriteria = "[Color] = '" & txtFirstColor & "' Or [Color] = '" & txtSecondColor & etc.

And for multiple columns from one combo box:

intRow = Me!ComboBox.ListIndex
stLinkCriteria = "[Color] = '" & Me!ComboBox.Column(0, intRow) & "' Or [Color] = '" & Me!ComboBox.Column(1, intRow) & etc.

hth
Jeff Bridgham
bridgham@purdue.edu