473,320 Members | 1,945 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Refresh Subform from Parameter Query

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
4 12918
MMcCarthy
14,534 Expert Mod 8TB
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
Hi,

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

cheers

Paul
Sep 8 '06 #3
PEB
1,418 Expert 1GB
In Unbound box After Update Event :)
Sep 8 '06 #4
Brilliant, thanks guys!!! i love this forum already!!!!!!
Sep 8 '06 #5

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

Similar topics

4
by: CSDunn | last post by:
Hello, I have a combo box (Combo7) that needs to call a function during the After Update event of the combo box. The function resides in an Access 2000 ADP Module called MMAnswerData_code. The...
2
by: John Baker | last post by:
Hi: I have a Pop Up form that involves a main form and sub form. The sub form has the results of a query on the main form. I need to automatically perform exactly he same action that takes...
2
by: S. van Beek | last post by:
Dear reader, I have a Form with a SubForm. On the MainForm there is a field receiving his content from a group query. If a change or append or delete a record in the SubForm the group...
1
by: Omar Anwar | last post by:
Hi. I am using form and subform in which form has combo boxes that sets the criteria for the query. i am using grouping in the select query and the contents of the query are displayed in the...
1
by: Macbane | last post by:
Hi There, I have a main form that with a subform which is based on a parameter query. I have 2 controls on the main form & which are used as parameters in the query. It all works fine and...
4
by: midlothian | last post by:
Hello, I have conditional formatting set up on a subform based on a calculated value in the underlying query. For instance, if Sales are >$1000, the query displays "Yes," otherwise it displays...
6
by: Chris Larmer | last post by:
I have two subforms in my main form. In the main form I want the user to select a customer, class, and date range. The 2 subforms are similar. One is the history records in the recent past and the...
1
by: Stinky Pete | last post by:
Hi everyone, I have been updating a file that uses a main form that contains a subform (as a datasheet). The main form really does not do anything on opening except maximizes to the users...
28
by: Rotorian | last post by:
Hello again, I have a subform that gets populated from a records query. I needed the subform to refresh once a record is added via another form. I accomplished this by re-running the query for...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.