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

How to auto update field on subform when field in main form is updated

I have a form with subform. When the main form is generated the number series of document on field (Called RegNum), and I wont that number series is auto updated to field (called RegNumD) on subform. I develop my application whit access 2010.

Could you please help me to solve that requirement?
Thanks
Jan 27 '13 #1
2 3943
zmbd
5,501 Expert Mod 4TB
You have provided very little information about the overall table design and relationships.

If you need a value to change between the tables... normally that isn't a really a good thing to have the same information stored in multiple locations and you will need to think about the normalization of the the database if not the entire overall design.

However, if your talking about pulling related records between tables:

Normally, there is a parent/child relationship between the forms wherein as the information on the parent form changes, links cause the subform to change in sync.

you can also do this via vba using the update event

take a look at: 41.How to select Records in an Access Subform from a Combo Box

you also might be interested in Discussion: Advantages of a Subform vs. Filtering
Jan 27 '13 #2
NeoPa
32,556 Expert Mod 16PB
If [RegNum] is a unique index of one table (on Main form) and [RegNumD] is a Foreign Key in another (on Sub form) and you want changes in [RegNum] to be reflected in [RegNumD]s automatically then you can set up a relationship between the two fields and ensure Referential Integrity is enabled for updates.

NB. This will effect these fields globally and is not a result of anything in either of the forms directly.
Jan 27 '13 #3

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

Similar topics

1
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...
3
by: jquest | last post by:
I have a database about services and installations as well as warranty and services for a company I run. The main form is the customer info form. On this I record names, address and phone numbers....
2
by: prakashwadhwani | last post by:
I have a (Main) form named : Stocks_Main and a Subform in that named: Stocks_Data The Subform is a continuous form There is a field in the subform called QTY_IN Now ... on the main form i.e....
3
by: wideasleep | last post by:
Hi everyone, I have a subform that is a continuous form. It will have mutiple records that connect to a single record in the main form. I have set this up but running tests show only one record...
0
by: Richnep | last post by:
Hi all,. I have a small issue I would like to resolve with VBA. I have a form which it's fields are bound to a table. Within that form is a subform which is a subtable. Tables relationship...
2
reginaldmerritt
by: reginaldmerritt | last post by:
Not sure if this is even possible, but i want to select a field in a sub form from a main form. I want to populate a field in the main form with a sub forms field value. eg. me.name =...
1
by: Bob Alston | last post by:
I have a system where many subforms are used. Often the size of the subform had to be larger than could be displayed without scrolling. I set the height of the subform to the typical height...
2
by: DeanL | last post by:
Hi everyone, I have a subform in datasheet view that is used to display the contents of a single table. I have another subform with a query feeding it to give a count of how many particular...
0
by: Anton Melamed | last post by:
Hi, I would very much appreciate any help give. Im creating database for handling stock of shoes with different sizes and orders. I have main form - Stock with a subform - Orders Each forms...
14
TheSmileyCoder
by: TheSmileyCoder | last post by:
I have noticed that when I resize the window of my main form, that any subforms that "fall" out of the visible area get closed. Now Access automatically reopens them if I expand the window again,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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
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
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,...

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.