Getting Query Results Using Controls on a Form 1

[bchess1]

I have a form with a combo box that has the following elements as the row source: "<";">";"<=";">=";"=". The name of the combo box is "cboSymbol".

I also have a text box that I can type a dollar amount in. The name of the text box is "txtAmount".

I want to run a query to pull data that matches the information on the form based on the values in these two controls. For instance, if I select ">" in the combo box and put 500 in the text box, I want all records where the dollar amount is greater than $500. Any thoughts on how this can be done? I tried putting the control names in the query grid, but it tells me it is too complex to calculate.

 

[dhookom]

There is an entire query by form "applet" at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

There is a combo box that allows the user to select the "symbol" as well as fields, grouping, sorting,...

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]