473,324 Members | 2,531 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,324 software developers and data experts.

Synchronizing 2 subforms of same table

Hi All,

I have a form that tracks problem issues. On that form I would like to
have 2 subforms with 1-to-many notes associated with each problem. On
the first subform I'd like to show a datasheet view of the associated
notes, with datecreated and notesubject. On the 2nd subform I'd like to
show a single form view of the actual note memo field.

I've placed an invisible sychronization field on the main form, which I
update from the On Current event of the first subform. The 2nd subform
uses this in the Link Master and Link Child fields.

It mostly works okay, but when I create a new record in the first
subform, and then click in the second subform to add the actual notes,
the second subform hasn't syched to the newly created record in the
first subform.

I'm wondering if anyone can tell me how I go about making this happen
automatically?

Note: Access 2003, if that's important.

Many thanks in advance!

Much warmth,

planetthoughtful

---
"Lost in thought"
http://www.planetthoughtful.org

Feb 27 '06 #1
1 3007
when you add a new record in the first subform, after the record is saved to
the table, you'll need to requery the second subform so that the newly
created record is included in the recordset. you might try using the first
subform's Form_AfterUpdate event procedure.

hth
"planetthoughtful" <pl**************@gmail.com> wrote in message
news:11**********************@j33g2000cwa.googlegr oups.com...
Hi All,

I have a form that tracks problem issues. On that form I would like to
have 2 subforms with 1-to-many notes associated with each problem. On
the first subform I'd like to show a datasheet view of the associated
notes, with datecreated and notesubject. On the 2nd subform I'd like to
show a single form view of the actual note memo field.

I've placed an invisible sychronization field on the main form, which I
update from the On Current event of the first subform. The 2nd subform
uses this in the Link Master and Link Child fields.

It mostly works okay, but when I create a new record in the first
subform, and then click in the second subform to add the actual notes,
the second subform hasn't syched to the newly created record in the
first subform.

I'm wondering if anyone can tell me how I go about making this happen
automatically?

Note: Access 2003, if that's important.

Many thanks in advance!

Much warmth,

planetthoughtful

---
"Lost in thought"
http://www.planetthoughtful.org

Feb 27 '06 #2

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

Similar topics

2
by: Tom | last post by:
The purpose of my form is to record multiple owners of businesses. The main form displays the business records. Subform1 is a continuous form consisting of only a combobox to select owners from a...
6
by: Steve | last post by:
I have a form, primary subform and secondary subform. A tab control takes up all the area of the primary subform. There are about 15 tabs on the tabcontrol. Each tab contains fields from the same...
3
by: Diana Gard | last post by:
Perhaps this is a design flaw, please let me know. I'm using Access 2000. I have a form with a tab control and 5 subforms within those tabs. The forms match with the tables: Client main,...
4
by: Dale Walker | last post by:
I've got a form that currently has a list box used to "find a record on my form" but the list in it is far too long and consists of fields of repeating data. Is there a way of creating a subform...
3
by: tlyczko | last post by:
I have a main form with 2 subforms, each subform references different data in the same table. How do I make sure each subform only creates NEW records in the referenced table and do not...
2
by: collegekid | last post by:
Hi everyone, basically my problem is this: I am using an Access 2000 format. And--I have four subforms in my main form. (Purpose of this is to track projects.) So in my main form I enter the...
1
by: Parasyke | last post by:
I have a form to display inventoried items using Access2003. On this form I have a subform that displays a list of all my inventoried items in the form of a DATASHEET. What I would like to do is...
7
by: philelpko | last post by:
Good Morning all, I have a main form with 3 subforms. All of the input data on all the forms is stored in the same table. I started getting the message "the changes you requested to the table...
0
by: sparks | last post by:
I was using this to swap out a form with subforms on it by just making a copy and tying each to copy of the same table. subformV1 tblVisit1 subformV2 tblVisit2 etc Select Case TabCtl0.Value...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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: 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...
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
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.