By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,218 Members | 1,326 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,218 IT Pros & Developers. It's quick & easy.

Synchronizing 2 subforms of same table

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.