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.
 
You must log in or register to reply here.

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

Main Form and two Subforms 2
Using form and subform not connecting to two separate tables 0
Using an append query in a subform 1
Expression is typed...... 2
Use field to update multiple fields 4
How to always get the top level form reference, when calling from any subform/subform... 0
Access Daily Entry with multiple entries per field 0
Using Linked Combo Boxes with a subform 1

Back
Top