2 forms for one table

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

I've created (2) forms to fill in one table

tbl_Inputs
frm_1
frm_2

Some of the information in frm_1 crosses over into frm_2 and vice versa (ie.
they share the same inputs into tbl_Inputs)

For some strange reason, the forms aren't updating together. For instance,
frm_1 will show 12 records and frm_2 will only show 6. How do I ensure that
the forms are synchronized with the data in the table?

Thanks,
Fred
 
Fred,

Are these two forms based directly on the table, or are they based on
queries? I have thought that maybe you have both forms open at the same
time... if so, I would suggest reconsidering your design, but that
depends on the reason for the dual tables idea.
 
Fred

If both forms are open at the same time then why not use tabs so that the
common information you want to view is on the form proper and the remainder
split between the tabs.

This way all data is in perfect sync and cannot be otherwise

Ray.
 
Back
Top