filter continous form with combo box

[shutzy]

i want to filter my form with a combo box and a couple of date boxes. with the combo box i cant use the wizard as it is not just from one table.

ive tried to put Me.Requery on the change event for my combo with the criteria in the record source to be the combo box but this doesnt work and im a little lost.

can anybody help

thanks

 

[edtab]

Your query grid can capture the value of your two date boxes in your form as
calculated fields.

e.g. Date1:[forms]![FormName]![TextBoxName]
You can do the same thing with the second
date box and call it Date2 or whatever name you like.

 

[shutzy]

ye thanks. the problem i have is when i change the dates or the combo box. how do i requery the results without requerying the whole form. i have a continous form that already has a combo box to filter the results but i did that through the wizzard but this form wont let me do that.

 

[shutzy]

sorry this is entirely my fault. cant remember what i did wrong but i did. its sorted now thanks