473,612 Members | 2,181 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Simultaneously data edit in main form and sub form

1 New Member
I have a database in MS Access. In that database there are five common fields/variables for Main form and sub-form.

Generally when I enter data in my main form it's auto populate in the sub-form (those common five fields) also.

But after finished the data entry (say after one week) when need to edit any field in the main form it's not editing simultaneously in sub-form.

I am not expert in VB code but know how it work. Can anybody help me on this?
May 22 '18 #1
1 761
twinnyfo
3,653 Recognized Expert Moderator Specialist
ashutosh2018,

Welcome to Bytes!

I do not htink this should require any VBA. If these five fields are common to both, then teh Sub-Form should have a Parent-Child relationship based upon those five common fields. Then, when the parent is updated, the child is automaticlaly updated.

Hope this hepps!
May 22 '18 #2

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

Similar topics

1
393
by: | last post by:
Is there anyway to update a control held on my main form from a child form? I've tried making the control itself public but I still can't seem to access it
1
2192
by: Bill Strass | last post by:
Problem: Access main form/subform as front end to SQL Server backend. Add/edit via subforms work fine. Not so with main form. Set up a master-detail form-subform using two views linked from SQL Server. The subform allows inserts an updates, while the main form will not. The only solution I can think of is to recreate using tables imported from SQL Server, so that the data is all local. This is despite the fact that the views in SQL...
1
3505
by: Susan | last post by:
I have a bound form and subform and am trying to enter the data in both forms programatically. The Linkmaster and Linkchild properties are set. My intent is to be able to look at the data before it is saved and then choose to save it or undo it. I have a Save button that just closes the form and a Cancel button that does an undo and then closes the form. I first enter data into the main form and then enter code into the subform. After the...
3
13981
by: gsb58 | last post by:
Hi! A mainform is being used to show records from a table in an sql database. A button on the main form will load a new form that allows the user to add, delete, update and search certain records in the underlying table of the main form. My question:
1
2802
by: jdicko5579 | last post by:
Hello: I am fairly new to Access and was wondering if someone could help me out. I have a main form with header. In the detail section of the main form, there is a subform. The subform has a header and a detail section. I am not able to tab from the last record in the main form's header to the header of the subform. Also, I am not able to tab from the subform's header, to the subform detail section. I have set the tab order for each...
2
1845
by: geowhe | last post by:
I am writing a VB6 application that opens with a Login form that allows the user to select one of several databases. Clicking 'OK' on the Login form opens the Main form. Something has happened to the Main form. It opens, but it is frozen. None of the controls respond, and the form itself can not be moved by clicking and dragging on the title bar. The entire form is totally unresponsive. At one point the MDIChild got set to true and the Main...
7
2157
by: rleepac | last post by:
Newbie here...I've been reading these forums for hours and I'm learning so much! I'm a Physician Assistant by trade but necessity has converted me to a pseudo-Access db designer. I have a db that is barely cutting it and I'm designing a new one "done right" so I can use the full potential of Access. Anyway...I know this is a simple task but I think I can't see the forest through the trees. I have a demographics form F_Employees with...
3
3426
by: cheweedog | last post by:
I have a form that contains 1 subform. Everything works fine until I tab into a textbox in the bottom of the main form. The data in the subform disappears on the form, but the table is updated. How to get the data visible in the subform until I exit the form. I have the record selector, naviagtion button and dividing lines set to "No", and the scroll bar to neither. I have the master and child link set to po#'s on the form/subform.
2
1551
by: mhegazy | last post by:
I have built a form on table which will navigate showing data stored in each record in the table. I need to restrict the edition of data while navigating records from the form. Edition can be permitted by clicking a command button for example (Edit) to change the stroed data. Can this happen? If so, please advise.
5
1496
by: mule1350 | last post by:
I have a main form ApplicationSubmission with the data entry property set. I'm trying to add a subform to it, that allows the user to select from a list of standard documentation the user anticipates will be required, associated with the Application they are submitting. In all my attempts, the subform is completely greyed out, including all navigation buttons. I have 2 tables, Applications and ApplicationDocs. Applications has a Autonum as...
0
8171
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
8615
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8568
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8422
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
7044
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
6081
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
4047
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...
0
4110
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2554
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 we have to send another system

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.