>< query from form
Posted on 2012-09-08
I have a form that has Combo boxes that are used as the criteria for a query.
The subform uses this data to show continuous records based on the query. If we imagine we are sorting picture frames by height and width in the subform
So if I pick a height on the main form height combo, say 300, I get all the available types of frame 300 high. If I select 200 Wide from the Wide Combo, then obviously I see all frame types 300 x 200. The criteria in the query is:
Like [Forms]![MyForm]![Height Combo] & "*" and or Like [Forms]![MyForm]![Wide Combo] & "*"
The "& "*" " allows nothing to be selected so I don't have to choose both height and width if I don't want to.
But what I need is >= Like [Forms]![MyForm]![Height] & "*" so I can see all picture frames greater than or equal too the size selected from the form. Is there any way to do this from the form.