M
MNKDurrani
Guest
Hi,
I need help in the following 2 problems:
I have two combo boxes on the form and print button.
In one combo box showing numbers 1,2,3,4 and 5.
Other combo box showing logical operator =,<,>
User is going to select from one combo box logical operator and from other number "means class field".
Print button prints the report. Report is based on the query.
In the query in criteria line I put the code
[FORMS]![MAINFORM]![CMB_CLASS]
It works for one combo box. Problem is to get criteria from second combo box or concatenate the both criteria’s. In query criteria line it should show like <2 or =3 or what ever user is selecting.
Second problem is in the same line. Three text boxes and 2 combo boxes showing "OR" and "AND" For example in one text box user enters last_name and then he select "OR", second text box enter city and then he select "AND" from second combo box and third text box enter department. After selection he is going to click the print button to print the report.
I really appreciate if anyone knows the solution or they used this type of thing in there application.
Thanks
I need help in the following 2 problems:
I have two combo boxes on the form and print button.
In one combo box showing numbers 1,2,3,4 and 5.
Other combo box showing logical operator =,<,>
User is going to select from one combo box logical operator and from other number "means class field".
Print button prints the report. Report is based on the query.
In the query in criteria line I put the code
[FORMS]![MAINFORM]![CMB_CLASS]
It works for one combo box. Problem is to get criteria from second combo box or concatenate the both criteria’s. In query criteria line it should show like <2 or =3 or what ever user is selecting.
Second problem is in the same line. Three text boxes and 2 combo boxes showing "OR" and "AND" For example in one text box user enters last_name and then he select "OR", second text box enter city and then he select "AND" from second combo box and third text box enter department. After selection he is going to click the print button to print the report.
I really appreciate if anyone knows the solution or they used this type of thing in there application.
Thanks
