If your form has several (up to 20) controls - probably text boxes - how do you build up search (SELECT) statement based on the entries in those controls. Some/all may be empty, or they could be all full.
Have done this in the past, using string concatenation, recursing through the controls. Is there a 'better' way?
If the contols are bound, does this complicate/ease the situation?
Ta - Andy
Have done this in the past, using string concatenation, recursing through the controls. Is there a 'better' way?
If the contols are bound, does this complicate/ease the situation?
Ta - Andy
