Using 2 subforms to populate the same table

  • Thread starter Thread starter CFP - Russell
  • Start date Start date
C

CFP - Russell

Guest
I have 2 subforms that I want to use to enter data into one table. I have a table with about 16 fields so I wanted to be able to enter the first 8 in one subform form then the next 8 in another. The problem I am running into is that when I enter data into the second subform it does not add to the correct record, it adds it to the next one. If I close the form and then re-open it everything is fine.

Does anyone know how to make it so that when a new record in the datasheet is added to the first subform, the row is also added in the second subform.

I believe that this can be accomplished using a requery command of some sort because it works once I close the form and reopen it.

Thanks,
Russell
 
I'm not going to ask why you need two subforms but you can use the Bookmark property to align the two subforms.
 
Can you please elaborate on how I would accomplish this.
 
Can't you use one subform with tabs for your two pages?
 
I'm not sure but my boss wants to be able to see both in order to fill out the information correctly.
 
I dont know who your boss his or his area of expertise. But two subforms to the same query and halfing out your data is NOT good.

Re-consider your design approach...again you're asking for trouble using methods which do not make sense logically.

Jon
 

Users who are viewing this thread

Back
Top Bottom