473,508 Members | 2,355 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How do i update a subforms subform?

1 New Member
Hi I'm using access 2003. I have a main form, with a tab control that has a subform with a subform. When I select an option from a combo box on the first tab of the tab control I need a field in the subform and subsubform to update. So far I can get it to work, but only the first record in the subsubform updates - the subsubform is display as a continuous form. I am using the following as an event from the combo box
Expand|Select|Wrap|Line Numbers
  1. [frmActionPlanHeader].Requery
  2. [frmActionPlanHeader]![frmActionPlanDetails subform].Requery
thanks
Jan 18 '12 #1
2 1285
Rabbit
12,516 Recognized Expert Moderator MVP
Expand|Select|Wrap|Line Numbers
  1. [frmActionPlanHeader]![frmActionPlanDetails subform].Form![some other subform].Requery
Jan 18 '12 #2
NeoPa
32,557 Recognized Expert Moderator MVP
You should be able to work it out from Referring to Items on a Sub-Form, but in this case, where we don't know the name of your sub-sub-form it could be :
Expand|Select|Wrap|Line Numbers
  1. [frmActionPlanHeader].[frmActionPlanDetails subform].Form.[Some Other Subform].Form.Requery
or, alternatively :
Expand|Select|Wrap|Line Numbers
  1. [frmActionPlanHeader].[frmActionPlanDetails subform]![Some Other Subform]!Requery
Jan 18 '12 #3

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

Similar topics

0
2328
by: Joseph J. Egan | last post by:
I am extending an existing Access/VBA app and need to update a subform displayed in continuous view within a containing form. The existing form and subform have worked fine to date with the...
1
7447
by: JJMM | last post by:
Hi, I have a form (form1) with a large number of subforms inside it (around 20 subforms), There is the possibility of filtering the data using a pop-up form that create/change a query (all the...
2
5319
by: Rosy | last post by:
I have a sub-form(company name & address) that is connected to my contact listing. When I change the contact, it doesn't update the subform until I close the main form or refresh. Is there a way...
1
2493
by: BartonConstruction | last post by:
Greetings all, I have a main form (frmClients) with two subforms (subVisits) (subAccount). I got the subforms to reflect what the main form is showing by linking master and child fields (I...
1
2577
by: RookieDan | last post by:
Greetings fellow Accessers! Im new but in Access, but I have some background in different coding. I have a programme loading customer data into Access belonging to BMW dealers in Europe. ...
4
6144
by: paquer | last post by:
Hello' How do I get the subform to print along with the main form? I want my user's to be able to go in the field with a printout of the info they need to populate in the database. So when they...
6
3667
by: Dave | last post by:
I want to put the information that the user selects in my combo boxes into a subform that lies on the same form as the combo boxes. Thanks for your help already, Dave
3
1517
by: natural | last post by:
Good Day, I was currently browsing on ways to update records within a form to a subform. and noted the following article by Alan Brown on how to make use of the With Me..Form.RecordsetClone...
0
30335
by: Gordon Padwick | last post by:
A form contains controls, one or more of which can be other forms. A form that contains another form is known as a main form. A form contained by a main form is known as a subform. A subform itself...
7
3584
Knut Ole
by: Knut Ole | last post by:
hello, getting stuck on some mysterious error.. i have a form and a subform, and im trying to update the subform as i open the main form. the update includes (as you can see) an attempt to create...
0
7224
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
1
7038
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7493
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5625
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5049
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4706
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3180
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1550
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
415
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.