Search for two things in one table 1

[supervi]

I use the variable prodselected for a listbox population.

This is the code as of now


ProdSelected = ProdSelected & "WHERE [Fixed Block]![Contract Number ID] = '" & "AC" & "'"



So this will search the COntract Number ID field of my table for "AC"

Now what i want to do is search for AC OR SC. How would i go about doing that? This doesn't worK but i imagine it would look something like this.



ProdSelected = ProdSelected & "WHERE [Fixed Block]![Contract Number ID] = '" & "AC","SC" & "'"




I know this doesn't work but i want it to display the values that contain AC or SC

If their are any questions let me know

 

[RoyVidar]

Hi!

[tt]ProdSelected = ProdSelected & "WHERE [Fixed Block].[Contract Number ID] IN ('AC','SC')"[/tt]

or
[tt]ProdSelected = ProdSelected & "WHERE [Fixed Block].[Contract Number ID] = 'AC' OR [Fixed Block].[Contract Number ID] ='SC'"[/tt]

Usually use dot (.) to as qualifier between table and fieldname

Roy-Vidar

 

[supervi]

That did the trick RoyVidar Thanks