Subform

[Guest]

I have a single table with 140 fields, which are organized on a tabbed form
to allow viewing all the fields.

I have inserted (using the subform wizard) a subform into one of the tabs
and when asked by the wizard connect ID to ID, but the record ID does not
correspond to the record ID on the other tabs.

If I create a new record all other tabs show the correct ID, but when I open
the tab with the subform and start entering data it creates a new record ID.

Is it possible to have a subform in this situation?
If not, what are my options show show about 65 fields on a single tab of the
form.
The nice part of the subform is that I have a scroll bar to move up and down
the subform to view all fields in a samll space.

Thank You,
Tim

 

[Guest]

Rather than have your subform tied directly to the data in the table, you
could try using unbound fields, and utilize a Save button/function when your
data input was complete. This should keep the primary table from attempting
to create a new record.

Sharkbyte

 

[Guest]

Would there be any other options that would be easier?

 

[Guest]

tlynn:

The problem would seem to be that there is not a corresponding record, in
the dataset of the subform.

Using code you could trigger an event to add a blank record, in the
subform's dataset, when a new primary record is created. This blank record
would only contain the ID, to allow the form/subform to synchronize. And I
don't believe you would need to include a Requery statement, for the subform.

Depending on the steps for creating a new primary record would determine how
difficult/involved this might be.

Sharkbyte

 

[Pat Hartman \(MVP\)]

I'll start with the lecture. If you have 140 fields in a single table, you
probably (but not absolutely) have a table design issue. It sounds like a
repeating group. If you want design help, just ask. Lecture over

To display data from the same record on multiple tabs, don't use subforms,
just add the controls to the individual tab pages. That will prevent you
from having update conflicts with yourself and will ensure that all tabs are
always on the same record.