473,803 Members | 3,913 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to refresh data on a MainForm

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 query will
cam up with another value.

How can I refresh the value as result from the group query in the MainForm
without closing and reopen the Form.

Docomand Requiry ?

Forms!FormName. Refresh ?

These commands do not help me.

Thanks for any help.

Kind regards,

Simon van Beek
Nov 13 '05 #1
2 2319
S. van Beek wrote:
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 query will
cam up with another value.

How can I refresh the value as result from the group query in the MainForm
without closing and reopen the Form.

Docomand Requiry ?

Forms!FormName. Refresh ?

These commands do not help me.

Thanks for any help.

Kind regards,

Simon van Beek

YOu might want to try the format
Forms!MainForm! FieldName.Reque ry
if the field is a calculated field. Otherwise you can try
Forms!MainForm. Form.Requery
in the AfterUpdate event of the subform.
Nov 13 '05 #2
S. van Beek wrote:
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 query will
cam up with another value.

How can I refresh the value as result from the group query in the MainForm
without closing and reopen the Form.

Docomand Requiry ?

Forms!FormName. Refresh ?

These commands do not help me.

Thanks for any help.

Kind regards,

Simon van Beek

YOu might want to try the format
Forms!MainForm! FieldName.Reque ry
if the field is a calculated field. Otherwise you can try
Forms!MainForm. Form.Requery
in the AfterUpdate event of the subform.
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1923
by: Dalan | last post by:
I'm sure there is a workaround for this, but haven't found it yet. I have a mainform with two subforms and after one or both of the subforms are updated, then clicking the Refresh button on the mainform (to show updated values), causes the updated subform(s) to automatically scroll up to one blank line if a new record was entered, or to the line that was edited. All of the prior subform records are not viewable or accessible until exiting...
0
2101
by: P Mitchell | last post by:
Hello I would like someone to be able to help with the updating of data in a lookup list in a subform. In short, is their a VB instruction that is the equivalent of performing the action of going to the menu and selecting Records and then Refresh? or To explain, based on a three table system where cars participate in rallies,
0
355
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 query will cam up with another value.
4
8247
by: Yogi_Bear_79 | last post by:
Self Taught here so please bear with me. I have the labelRestrictSites as private on the MainForm.cs. I then access the labelRestrictSites.Text thru the public string LabelRestrictSites from another class. So when I add labelRestrictSites.refresh code to my class I get an error because the labelRestrictSites is private. How would I refresh? ****************************************
3
4064
by: juky | last post by:
Hi all, I have 2 applications one in VB.net and the other in VC6. I need to pass data between them. How can I do it? what's the best way to implement such communication ? Any comment will be appreciate. Thank you. Juky
3
21152
by: plgii | last post by:
I have modal pop-up form1 showing list of items. There is a button that opens a new modal pop-up form2 which is a tabbed form (not subform) to add items to form1, form1 is still open behind form2. This all works fine, but when you click save button on form2 it saves new data to database and closes taking you back to form1 but does not refresh new data to form1 unless you (shift F9) or close form1 and reopen or use refresh button on form1. I...
3
4274
by: ApexData | last post by:
COMBOBOX REFRESH DILEMMA ' I have been working for hours trying to figure out how to requery a combobox in a subform, from a Popup form ' that this subform had launched. Basically, I designed a form that pops up when the user dbl-clicks a combobox. ' This popup form displays the table that the combobox uses. The user can change the content, and the combobox ' rowsource in-turn will change. This all works great in my mainform, but...
9
1990
by: kirk | last post by:
I have program.cs, my "main" form and then a "settings" form. My "main" form existed for awhile and I had constants, instantiations, properties, etc within it created. I went to create my "settings" form and constantly found myself adjusting my "main" form entities to be static and inevitably just passing in the "main" forms 'this' instance to the "settings" constructor to simplify it all.
5
2475
by: BlackBox | last post by:
I have a Listbox1 in the main form and I can add listbox1 items in the parent form. But when I close the parent form Listbox1 in the main form does not get refresh. I need to re-open the app. Any idea on how to refresh items in the main from from a parent form without opening the app. -Thanks
0
9703
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9564
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10295
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10069
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9125
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7604
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6842
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5500
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
3
2970
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.