473,321 Members | 1,748 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,321 software developers and data experts.

Requery a subform that is in a navigation form

This topic has quite a few posts with various remedies that I have read but haven't been able to locate one that works with what I am doing. I use Access 2016. I have a navigation form. In the first tab of the navigation form, there are (3) subforms which contain data from five separate tables, all of which share a 1 to many relationship among themselves.

The subform that I cannot get to update displays customer contacts in a continuous form. The contacts table are (child records) of a customer table (parent record).

I have a command button within the the same tab of the navigation form to Add a new contact. This launches a separate form (call it a popup) to add a new contact and then returns to the navigation form after saving. The record gets added but I have to navigate away from the current record getting the new contact and then back in order to see the changes. Before putting these forms into the navigation form, it all worked fine.

What is the proper method to have the continuous form update automatically upon returning? I have tried a myriad of the Forms! and Me! syntax from the various examples but all fail with a message similar to: the continuous form is unknown.
Dec 8 '16 #1

✓ answered by PhilOfWalton

I presume you have tries something like thin on the AfterUpdate of your Pop up

Expand|Select|Wrap|Line Numbers
  1.     Forms!MainForm!Subform.Requery
  2.  
It's worth checking that the subform name has the same as the subform SourceObject

Phil

2 4360
PhilOfWalton
1,430 Expert 1GB
I presume you have tries something like thin on the AfterUpdate of your Pop up

Expand|Select|Wrap|Line Numbers
  1.     Forms!MainForm!Subform.Requery
  2.  
It's worth checking that the subform name has the same as the subform SourceObject

Phil
Dec 9 '16 #2
Thanks for your response Phil,
Yes, I have been trying statements that are similar and by all rights, should have worked. Well, they would have worked if I had the name of the subform correct. The name of the entire navigation form is frmContractorNavigation but what I missed was the name of the subform which I discovered is the entire area that encompasses the 3 subforms. That particular area of the Navigation form is somewhat difficult to select. I thought I was supposed to reference the name of the customer contacts subform. The correct code follows:
Expand|Select|Wrap|Line Numbers
  1. Forms("frmContractorNavigation").[frmDisplayContractorSubForm].[Form].[frmCustomerContactGrid].Requery
Dec 10 '16 #3

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

Similar topics

3
by: jburris | last post by:
I have been through enough of these threads to think that this should be an easy fix... but, are there circumstances in which the following code syntax does not work? =!!.Form! (this is out of...
0
by: araman | last post by:
Hello, I have a form and subform . The Main form contains four boxes to enter criteria for the query that fills the subform. Outside of the navigation form it works great. when i add it to the...
0
by: ahd2008 | last post by:
Good day, I hope there is someone who can help me to resolve my problem. I have created a number of forms, and decided to use navigation from to put them all in the navigation form. In the...
16
by: ahd2008 | last post by:
Good day all, Can anyone enlighten me on how to switch between tabs in navigation form? My navigation form has 5 tabs, and for some reasons I need a code to switch, between those tabs. I have...
5
Seth Schrock
by: Seth Schrock | last post by:
I have created a navigation form in Access 2010 using the horizontal tabs, 2 levels style. This form is my startup form. In the top row, I have to options. Under each option are several sub-tabs...
4
by: mabsalam | last post by:
I create a form on my database called "FILTER FORM", this form has a textBox and a button. TextBox on the form allows me to enter the criteria I needed for my report and the report will display if a...
1
by: KurtBergman | last post by:
The Access 2010 Navigation form has very little documentation. One issue is moving to a different Tab (subform) in data AddMode. The assumed method is DoCmd.BrowseTo...
4
by: JamesHalko | last post by:
I'm a new user to access so I will try to explain this to the best of my abilities. I created a search form for my records, 'PBTSearchF' When I open the form alone it works fine. However, I want...
1
by: Sarkar | last post by:
Hello, I have a navigation form which includes some forms and reports in the navigation tab to allow switching between forms and reports. The issue is that when the user loads the navigation form,...
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
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...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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)...
1
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...
1
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: 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.