473,486 Members | 2,427 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

How do I requery subform within a navigation control?

Seth Schrock
2,965 Recognized Expert Specialist
I have a situation where I have a popup form that when I close it, I want it to requery the subform that is opened in the currently selected navigation control tab. My problem is that I don't know how to reference it. I have tried
Expand|Select|Wrap|Line Numbers
  1. Forms!frmHome.NavigationControl0.Requery
  2. Forms!frmHome.NagigationSubform.Requery
Neither one does anything. I can't think of anything else to try.
Mar 4 '15 #1
3 3113
twinnyfo
3,653 Recognized Expert Moderator Specialist
There might be some info here: Navigation Controls.

I know Nav Controls are a real bear to understand. MS didn't do a good job of making them easy for us. You may also try to Contact Z, as he seems to be the only one I know who has any slight grasp of how to work with them in VBA.
Mar 4 '15 #2
Seth Schrock
2,965 Recognized Expert Specialist
Thanks twinnyfo. That had the answer that I was looking for. I also discovered that I had changed the data, but it hadn't been saved when I tried to do the requery so I wasn't seeing the results like I thought I would.
Mar 4 '15 #3
Brilstern
208 New Member
@Seth
Not saving my VBA before running it again gets me so much!
Mar 5 '15 #4

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

Similar topics

5
10583
by: Ellen Manning | last post by:
Using A2K. I need the syntax to set the recordsource for a subform within a subform. The "main" subform's recordsource changes based on user input. I need to change the recordsource on the...
6
3157
by: ryan | last post by:
I created in design view a subform within a subform. However the subform within the subform in only visible in design view. In form view the subform within the subform is not visible. I have...
3
5320
by: Mike Jakes | last post by:
I hope that someone can offer a little advice on this one - I've searched the group but can't find an answer. I think that I'm doing something really stupid or missing something trivial, but see...
14
17972
by: mchlle | last post by:
How can I filter records of a subform that is part of a tab control? The filter works fine on the form when it is not part of the tab using this in the macro condition: !!="Today" I have a main...
5
3309
by: bplantes | last post by:
I have a "Dashboard" in a tool I am building which has a list of different buttons. Clicking on each button will display different subforms which show up in a window to the right of the menu. One...
1
2588
yosiro
by: yosiro | last post by:
First, sorry for my english so bad. I want to create print button from a form that not working when i use navigation control. Step 1. http://i47.tinypic.com/2wp1d9e.jpg I want to print data...
5
5497
zmbd
by: zmbd | last post by:
Question first: Is there the equivalent ! that can be used in the form control’s recordsource parameter such as in a combo-box? Ok, now for some context: I’m Playing with the new “Navigation...
17
3717
zmbd
by: zmbd | last post by:
So, there's the ole "Parent" form and "Child" form. These work very well and the information pulled is correct; however, we want the elapsed time between entries that show on the sub form. Not an...
6
37310
by: ccocker | last post by:
Hi guys, I have in the past referred to controls on subforms without any issue, however with the new navigation control there does not seem to e a subform to refer to other than NavigationSubForm....
2
6353
Seth Schrock
by: Seth Schrock | last post by:
I have a navigation control on a form with multiple tabs. Depending on the user permissions, the user might not have permission to view the first tab (the default tab). I have the code to make the...
0
7100
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,...
0
6964
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7126
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7175
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6842
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
4559
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
3070
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3070
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1378
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 ...

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.