2 forms for one table

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
 
S

Steve Schapel

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.
 
R

Ray

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple forms show/load best practice 3
Use List Box to select a paramter for a query 5
Two forms to one table 2
Math in forms 3
Form for Parts-Tools Lists 0
2 Forms for 1 Table 7
Multiple Forms Entry 4
table linkage and sub forms 4

Top