By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,842 Members | 2,186 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,842 IT Pros & Developers. It's quick & easy.

Prompted Twice For Filter Criteria

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.