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

Parameter query

P: n/a
I have a subform whose source is a parameter query. How can I
programatically change query parameters and refresh subform without
showing "Enter Parameter Value" dialog?

Apr 23 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
here's one solution: remove the parameter from the query. put an unbound
textbox control or combo box control on the form, so the user can choose the
value to be queried against. add code the the control's AfterUpdate event
procedure to requery the subform, as

Me!SubformControlName.Form.Requery

note that you must make sure you are using the *correct* name of the subform
control. if you're not sure, go to
http://home.att.net/~california.db/instructions.html and click the
SubformControlName link for illustrated instructions on how to identify the
correct name.

in the query design view, put criteria on the field that previously had the
parameter, with a reference to the unbound control on the form, as

Forms!FormName!UnboundControlName

hth
<jo************@yahoo.com> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...
I have a subform whose source is a parameter query. How can I
programatically change query parameters and refresh subform without
showing "Enter Parameter Value" dialog?

Apr 24 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.