search code

[kmmuelle]

How would I change this piece of code to search and display items from 2
different fields? Say if I searched for "Pen" in one combo box and there
was a pen in the Field item1 and item2 and want them both to be displayed?

If Not IsNull(Me.Combo12) Then
str = str & "([itemid] = " & Me.Combo12 & ") And "
End If

Thank you

 

[pietlinden]

How would I change this piece of code to search and display items from 2
different fields?  Say if I searched for "Pen"  in one combo box and there
was a pen in the Field item1 and item2 and want them both to be displayed?

 If Not IsNull(Me.Combo12) Then
 str = str & "([itemid] = " & Me.Combo12 & ") And "
 End If

Thank you

why do you need to search two different fields for the same data?
Sounds like a normalization issue. Post the relevant table structures.