search code

  • Thread starter Thread starter kmmuelle
  • Start date Start date
K

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
 
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
Click to expand...

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