Subform Fields onto Tabs

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have a main form with a subform. As expected, entering the data in the
main form and subform automatically created all autonumber PK and FK
numbers.

I now, however, would like to "break" the subform and move its fields onto
multiple tab sheets.

Thus far, I have copied the subform let's say 3 times, renamed the subform
into sfrm1, sfrm2, sfrm3. Then, for each subform, I removed the fields
that were not needed (in its totalitly of the 3 subforms, I still have the
same number of fields).

At that time, I inserted (F11) the subforms onto their respective tab sheets
on the main form.

Unfortunately, in the process the relationships amongst the fields are not
maintained. I get an error that another field is required before I could
even move to the 2nd tab after having entered data in the 1st tab.

So, my question is: When having a subform on a mainform, how can I move
the fields of the subform onto different tab sheets w/o losing the
relationship amongst the fields?
 
If you use 3 different subforms, Access must save the record in one before
you can move focus to another. If the record is incomplete, you may not be
able to save the record, so the approach cannot work.

One option might be to put the tab control in the subform. You can then
place the different fields on the different pages of the tab control, and
because they are all in the one form you can move from page to page without
having to save the record.
 
Back
Top