Prompted Twice For Filter Criteria

[Colin]

I created a macro that starts a filter on a query. The criteria in the
query is:
Like [Enter Group Name] & "*"

The macro is initiated by pressing a command button on the form. This
works fine.

However, when this form becomes an unbound subform of another main
form, I'm prompted twice for the value of the filter (i.e. the group
name to enter). How can I stop the double prompt when my form is used
as a subform?

Thank You

[Kevin Rollo]

One thought ..... have you tried setting the criteria name as a query
parameter?
In Query design from the menu select Query, Parameters and as per below
define> Enter Group Name as the parameter.

"Colin" <co*****@sympatico.ca> wrote in message
news:65**************************@posting.google.c om...

I created a macro that starts a filter on a query. The criteria in the
query is:
Like [Enter Group Name] & "*"

The macro is initiated by pressing a command button on the form. This
works fine.

However, when this form becomes an unbound subform of another main
form, I'm prompted twice for the value of the filter (i.e. the group
name to enter). How can I stop the double prompt when my form is used
as a subform?

Thank You