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