Filter report based on form values

[plavookins]

I created query. After that created report based on that query. In query I put criteria that will looks for values in form that I created earlier (three values, number and two dates). When I run report filter form appeared. If I just click on OK report returns all record which is ok. But when I chose some value from form it return blank report but I now that value exist in database. Other two fileds (dates) work ok for report.

I don't know why report don't work properly based on combo box value on filter form. Just to mention that I worked with this type of reports and filters earlier, but now it just won't work properly.

 

[ted.martin]

Try putting a full stop instead of a ! between [Filter].[Combo15]

 

[plavookins]

I finally figured it out. I removed ID field from query.. That is it....

 

[plavookins]

Another similar problem...... I added another combo box on that filter form (bombo box connects two fields in table , firstname and surname) but it doesn't filter anything when I run report. It appears that the right informations are in combo box when I click on it.... see picture. I suppose the problem is connecting two table columns......