adding multiple searches in where condition

[Kyle02]

Hey,
I currently have this for my where condition, and searches the form based on the clientID selected in the combo box. ]

The catch now is i have to add another search.



="[ClientID] =" & [TempVars]![ActiveControlValue]

now i have to also search [ProductID]

The combo Box is set up like this:

ClientID....ContactName....ProductName....ProductI D
Hidden.....Visible..............Visible........... ..Hidden

how can i add [ProductID] into the existing where condition to add an additional parameter?
thanks

[ssanfu]

Do you know about the "Column" property of the combo box?

[ItsMe]

Why do you have ProductID and client ID in the same combobox?

[Kyle02]

Yes, Where i know i am going wrong is the syntax.

It is a macro, after update..
ObjectType: Form
ObjectName: frmAccount
Record: First
WhereCondition: (Originally: ="[ClientID] =" & [TempVars]![ActiveControlValue])

Everything Works fine like that. Searchs on the clientID perfectly. Now I want to Add in another ProductID... So

="[ClientID] AND [ProductID] =" & [TempVars]![ActiveControlValue]

You mention the column combo box property. But this isnt stating the cbobox it searches from, just the id...

If it were to use the column idea, then cbogotoclient.Column(3) (ProductID) and cbogotoclient.Column(0) (ClientID) but that doesnt support what im doing. Or is my thinking wrong?

ItsMe: Yes i do, In my Form (frmAccount) I need to search based on two criteria, ClientID, and there specified Product, Each Client Can have multiple Products, so i chose to set it up in one cbobox to speed up the process.

[ssanfu]

I don't know the logic behind your combo box, but you posted

The combo Box is set up like this:

ClientID....ContactName....ProductName....ProductID
Hidden......Visible............Visible.............Hidden

so, if the combo box name is "cbogotoclient", I would try:

="[ClientID] =" & Me.cbogotoclient & " AND [ProductID] = " & Me.cbogotoclient.Column(3)