having a subform but leaving a notes field on a different tab

[bluegrassstateworker]

Having a bit of a lapse with a subform and tab. I am just now
creating the forms which will allow assignment of a designated parking
spot for multiple parking lots. The relationships and data integity
are good and have tested. The main form I have now uses a data source
table called SPACES. There is a subform that has datasheet view of 5
fields of the contents of the SPACES table. On that same form I have
a combobox from the LOTS table in which I can select a LOT and that
sets a filter that will display all of the spaces within that lot . I
can easily see which spaces are unassigned; 20 or so at a time and I
can also easily use a dropdown of available employees to make
assignements within the subform.

My challenge is that I would like to be able to have a tab on the
subform that contains a notes field and some other less-used
information from a record in the subform I somehow set focus on. Does
anyone have any examples (link or otherwise) of a form I could look at
that has a subform with some data on one tab and the remainder of the
data on another? Any pointers in the right direction appreciated.

 

[Arvin Meyer MVP]

You cannot have a control from a subform on another tab. A subform isn't
really a form until it gets focus. You could build a separate subform with
just the ID (the same linked ID as the other subform) and a notes field.
That might cause some problems, with saving the edited record, but you
should be OK if you have the locking set to "No Locks"