Update Related Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave C - 31 Dec 2005 18:40 GMT

I have two forms displaying data from two related (one to many) tables. Form
1 displays data from table 1 (one) and form 2 from table 2 (many). I've used
the wizard to provide a button on form 1 to launch form 2 using the related
fields to provide the connection between the two sets of data.

I would appreciate help on how to have form 2 update automatically when the
record on form 1 changes. I can achieve this by clicking the the button again
but I'd like to have form 2 update without having to do this.

Thanks in advance for any assistance.

Dave

Reply to this Message

Rick Brandt - 31 Dec 2005 19:30 GMT

> I have two forms displaying data from two related (one to many)
> tables. Form 1 displays data from table 1 (one) and form 2 from table
[quoted text clipped - 10 lines]
>
> Dave

There is more than one help topic (and examples) that explain exactly how to do
this. Look for the topic...

Synchronize records between two forms

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

John Vinson - 31 Dec 2005 20:53 GMT

>I have two forms displaying data from two related (one to many) tables. Form
>1 displays data from table 1 (one) and form 2 from table 2 (many). I've used
[quoted text clipped - 8 lines]
>
>Dave

There are ways to do this (follow the help links suggested) but... is
there some reason you can't make the second form a Subform of the
first (perhaps putting it on a Tab page if you're short of screen
space)? This would maintain the link automatically with no code at
all.

John W. Vinson[MVP]

Reply to this Message