I want to build a sql string from a form. I have four dropdown boxes, if there is a selection in a box it gets put in the sql string.
Problem is if there is no selection then my string doesn't work.
to keep it simple lets stick to two pulldowns
Ex.
sql="select * from product where Foundby =" & PullDown1 & Product=" & PullDown2
If PullDown2 has no selection it should be a wildcard but the * doesn't seem to work.
Without building a bunch of if statements with different sql strings is there an approach I can take to still retrieve all data regardless of whether PullDown1 or PullDown2 has a entry.
