Can I use the same table to create two subforms?

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

Guest

The main form is a separate form(Facility), the first subform (Violations) is
relating fine. The second subform (Payment) is also based from the same
table as the first subform. I believe this is my problem. Am I correct?
 
sherrill said:
The main form is a separate form(Facility), the first subform
(Violations) is relating fine. The second subform (Payment) is also
based from the same table as the first subform. I believe this is my
problem. Am I correct?
Click to expand...

In general two subforms using the same source table residing on the same parent
form would not be a problem. If both subforms were trying to edit the same
*record* in that common table then yes, that will cause a write-conflict error.

I would suggest a single subform containing a TabControl to logically separate
the Violation from the Payment fields.
 
Back
Top