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

How to Synchronise Parent and Sub Forms

** Edit **
This post was posted by mistake into another thread (To populate listbox in subform from value selected in parent form), which may contain details relevant to this question.
**

Now I have a problem to synchronise parent and sub forms.

Say in parent form I have a combo box that when a value: a person is selected, a list box on the same form will be populated with the bank names where this person holds account and address of the branch.
I have to use query to populate the list box also cos the bank name and address are held in 2 different tables.
A person can be connected to more than 1 banks and 1 bank can be connected to more than 1 persons.

When a row in list box is selected, the sub form initially should display the details of the account held in that branch that has a flag "main" selected. But when left/right arrow button is pushed, the sub form can display the details of other accounts held in the same branch.

On the recordsource of the parent form, I put the name of the table that connects person ID to account ID.
And on the recordsource of the subform, I put the name of the table that has details of each account ID.
A person can have more than 1 accounts, but only 1 account that is marked as "main".
So the main and child field is the account ID on both tables.

My question is how to synchronise the display of the parent and sub form. Somebody suggested using recordsetclone and bookmark, but I'm not familiar with this concept, so any tips are much appreciated.
Aug 29 '11 #1
0 1249

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

Similar topics

0
by: amber | last post by:
Help! In my project, I have a 'navigation' form that opens first, and from there the user chooses from multiple 'modules'. Each module has a 'main' form that contains a menu to open many...
2
by: Terrance | last post by:
I'm hoping someone can help me solve a small problem that I have. I'm working on a windows app that has a parent form. On the parent form there are several objects such as a listview, buttons and...
25
by: Steve Jorgensen | last post by:
Yup, Steve's full of tips, but hey, it makes him feel important, right? Ok, here goes. I've been trying to improve encapsulation by putting code in the same object as the stuff it affects, so I...
3
by: Roland Wolters | last post by:
Hi, I have parent-form that displays a list of product-details. When the user clicks on a line a child form opens that displays further details. The user then can alter these details. On the...
1
by: AssanKhan Ismail | last post by:
Hi, I have two aspx form say Frm1 and Frm2 . In Frm1 one dropdown box and one button is there.After pressing that button it opens Frm2 ,in Frm2 i choose one data from Frm2's dropdown box when i...
3
by: Graham Blandford | last post by:
Hi all, Wonder if anyone can shed any light on this scenario. I have an MDI form, Form1, that opens a child window Form2.. - simple enough. However, from Form2, I would like to open a form...
25
by: PhilBowen | last post by:
I am using Access 2003. I want to synchronise sub forms via buttons shown on the main form. The main form provides information for each application that is received. The sub forms accessed via...
0
by: mplands | last post by:
I have an access database that has two main elements; -Client Detail -Properties To expalin my problem as sussinctly as possible may be difficult but here i go... I have created a form called...
0
by: newbe | last post by:
new to vs 2005 and creating a mdi application. have created a mdiparent parent page fill parent form with child form1 and from mdi menu open child form2. when creating a public variable in form2...
4
by: henpat | last post by:
Hello all I have a MDI Parent Form with some childs. I need to know how can I setup a child form in order to disable access for other forms "in the back". I need that only the active form be...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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...
0
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...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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.