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

Refresh Subform from Parameter Query

P: 6
Hi all,

This is really begining to do my head in!!! I have a query that im trying to run, but i want it to refresh a subform, not open up into a new window.

I have a CD database and so far i have my main form with an unbound box where the user can input the artist name, i then want the subform, which is all the required fields from the query, to be updated based on what the users inputs into the unbound box.

I can get the data to return in datasheet view, but how do i get it to update the query in the subform??

Thanks in advance

Paul
Sep 7 '06 #1
Share this Question
Share on Google+
4 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
After adding your data to the subform type the following line of code

Forms("MainFormName").Controls("SubFormName").Requ ery

Be careful of the SubFormName it is not necessarily the name of it as a form. Look in properties - Other - Name.


Hi all,

This is really begining to do my head in!!! I have a query that im trying to run, but i want it to refresh a subform, not open up into a new window.

I have a CD database and so far i have my main form with an unbound box where the user can input the artist name, i then want the subform, which is all the required fields from the query, to be updated based on what the users inputs into the unbound box.

I can get the data to return in datasheet view, but how do i get it to update the query in the subform??

Thanks in advance

Paul
Sep 7 '06 #2

P: 6
Hi,

Thanks for the reply, Where do i need to type that code?

cheers

Paul
Sep 8 '06 #3

PEB
Expert 100+
P: 1,418
PEB
In Unbound box After Update Event :)
Sep 8 '06 #4

P: 6
Brilliant, thanks guys!!! i love this forum already!!!!!!
Sep 8 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.