N
Nicholas Scarpinato
I have a form that generates a SQL query string based on criteria that is
selected by the user. What I want to do is use that string to generate an
Access query which can then be used as a SourceObject on a subform. The
string is displayed on the form in a text control. Is this possible?
On a side note, I'd like to be able to change the comboboxes on the form to
reflect changes in the selections made in the previous comboboxes. For
example, there are five choices for the user to select from for search
criteria, and there are five separate search criteria boxes on the form. If
the user picks SKU Number from the first search criteria box, I want to
eliminate that choice from the remaning four, and so on down the line, IF the
user chooses "AND" for the next search criteria. If the user chooses "OR", I
want to leave that option available in the remaining search criteria
selections. So, if the user is searching for SKU Number 12345 OR SKU Number
23456, I want SKU Number to remain a valid choice for that second search
criteria on the form.
selected by the user. What I want to do is use that string to generate an
Access query which can then be used as a SourceObject on a subform. The
string is displayed on the form in a text control. Is this possible?
On a side note, I'd like to be able to change the comboboxes on the form to
reflect changes in the selections made in the previous comboboxes. For
example, there are five choices for the user to select from for search
criteria, and there are five separate search criteria boxes on the form. If
the user picks SKU Number from the first search criteria box, I want to
eliminate that choice from the remaning four, and so on down the line, IF the
user chooses "AND" for the next search criteria. If the user chooses "OR", I
want to leave that option available in the remaining search criteria
selections. So, if the user is searching for SKU Number 12345 OR SKU Number
23456, I want SKU Number to remain a valid choice for that second search
criteria on the form.