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

How to synchronize a main form with its sub form

The main form (frmPoduct) has primary field - ProductID (text) , ProductCategory(text) and more…
The main form displays one record at a time
The sub form show all the records with the same ProductCategory as in the current record in the main form.
Can I make it links in the opposite direction : when I select specific record in the sub form I need this record become the current record in the main form ?

Thanks in advance
Sep 3 '16 #1

✓ answered by zmbd

It would be helpful to understand how the Parent and Child forms relate to each other.

I'm guessing that you have something like (mind you this is very simple mock up):


So that say the parent form has only the names, maybe the primary contact telephone number, and the sub-form has the full contact information

If so, then you can use the on_current event of the subform to cause the parent form to move to the correct record. There are also "custom events" that you can program; however, those are not for the faint of heart.

If you will clarify the relationship between the forms we can help you focus on the correct path.

1 1100
zmbd
5,501 Expert Mod 4TB
It would be helpful to understand how the Parent and Child forms relate to each other.

I'm guessing that you have something like (mind you this is very simple mock up):


So that say the parent form has only the names, maybe the primary contact telephone number, and the sub-form has the full contact information

If so, then you can use the on_current event of the subform to cause the parent form to move to the correct record. There are also "custom events" that you can program; however, those are not for the faint of heart.

If you will clarify the relationship between the forms we can help you focus on the correct path.
Attached Images
File Type: jpg 967193_MockSplitForm.jpg (49.9 KB, 445 views)
Sep 3 '16 #2

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

Similar topics

1
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
2
by: chris vettese | last post by:
I've been having trouble with this for a long time. I have a form that has many subforms. In the subforms I have unbound text boxes in the footer that sum a field. I want to Display this sum on...
9
by: William Wisnieski | last post by:
Hello Everyone, Access 2000 I have a main form with a continuous subform. On the main form I have a text field called . It gets populated based on what the user selects in a field on the...
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: 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...
7
by: Bmack500 | last post by:
I'm using visual studio 2003. I have much of my code in my main form, called 'frmMain'. When I create a class to perform string ops and such, it sometimes needs to refer to functions in the main...
1
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...
2
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...
6
by: BEETHOVEN | last post by:
I have an option group called Issue_Type on my main form F1_Member_Demographics_Main. When I select one of the 3 options on the main form from the option group Issue_Type I want to limit the sub...
10
by: ittechguy | last post by:
I'm trying to create a search form which is located in my main form. I need it to filter several subforms. My main form contains building name and room name. I have a subform for customer...
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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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.