query not giving correct results

[schalkse]

Hi,

Been chewing my gums on this one for a few days.
Have a report which has a query as a record source. Pending on the choices made in several listboxes it spits out results from that group.

Now, only when my cursor is in the listbox and i open the query and then the report by clicking on it, it gives me the correct results. When i use the button, it just gives me all data. It is like the query is not run before opening the report.

Anybody a solution, so it works?

Thanks

 

[Rickster57]

query

Are you able to post your db?