Hi all,
I have a continuous form with some controls on the form header to navigate the records.
The first is a search textbox which can look for 'like' keywords in any of 3 of the fields. This works perfectly:
Me.Filter = "[FunctionalLoc] Like '*" & Me.Text79 & "*' Or [Description] Like '*" & Me.Text79 & "*' OR [ConstTypedesc] like '*" & Me.Text79 & "*'"
However, what I'd like is another text box (or 2) that searches through the same fields but combined with "AND" with the one above but I've no idea how to put the syntax together :-(
Please help?
I have a continuous form with some controls on the form header to navigate the records.
The first is a search textbox which can look for 'like' keywords in any of 3 of the fields. This works perfectly:
Me.Filter = "[FunctionalLoc] Like '*" & Me.Text79 & "*' Or [Description] Like '*" & Me.Text79 & "*' OR [ConstTypedesc] like '*" & Me.Text79 & "*'"
However, what I'd like is another text box (or 2) that searches through the same fields but combined with "AND" with the one above but I've no idea how to put the syntax together :-(
Please help?