Hi

I need to define this query:

I have 2 unbounded fields : ShowMonth and ShowYear (Each field represent the month and the year of Date field)
And UserName field

I need to define query that shows the dates and the UserName accordding to ShowMonth,ShowYear and UserName field (Without SQL).

I will be happy if serious answers will be post

Thanks

The query works when I run the query alone and the Form is open.
But when I open the forum (That contain the query in the subform) I get the popup fields that related to the query and I always need to fill it again and again - twice per open form.

What I need to do to overcome this problem?


Thanks

When the form opens the subform query was loaded first and then the popup query fields shows.

I think that if I could disable the query first and after that the to enable the query the problem will be solved

Any Idea?????