I've since gotten this to work the way I intended, but I wanted to update it to allow the user to search on two different fields if need be. How can I make it also look to another variable for the searching like the code below?

cmd = [exec InTransitRN ?']+fdBlNo+[']

So basically I want them to be able use the above if they have that number, but also search on this one:

cmd = [exec InTransitRN ?']+fdRefNo+[']

Is there a way to combine the two somehow or does it have to be done separately? Would a CASE statement work here? I was thinking of having it check to see which text box had data in it and use the associated code based on that. I don't know if that's a good way to do it though.