Update Related Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Dave said:
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
Click to expand...

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
 
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
Click to expand...

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]
 
Back
Top