S
Sleepless in Salem
Readers All:
If this is trivial, I apologize. I feel like I am tantalizingly close to
working through this problem but I am not quite there and I am burning a lot
of time getting to the next step. If the problem wasn't central or not
repeated in the project, I wouldn't ask for help. I have most of this
working but I am not able to limit/restrict/control data in the form as much
as I need. Thanks in advance . . .
In a form (containing what I think of as 'serial' subforms - each identical
subform representing a record or potential record in a second related table
and each subform selected based upon serialized information from a common
field - if each record weren't so large or so easily comprehended in vertical
format I would use something more like a customer-work order table-linking
form and I don't think I want all of the horsepower and
user-driven-variability of a pivot-table), I need to display a table of
relatively static information. I want to select a non-editable record based
upon a field and have it populate a few additional fields for display only.
I need the data in that selected record to be used to drive the selection of
records for display in the subforms (with each subform tied - locked? - to
the form's data) so that, while in the subform, the data in the common fields
cannot be changed. Having accomplished selecting and populating the form
data, I want to move to the first subform into a specific field (the
identifying field for the serial nature of the records and permit a selection
from a drop down list. Upon selection, I need to query the data to determine
if a record (and one or more of the next 3 in series) already exists in the
table displaying those that already exist in the appropriate subform and
putting the serial data in the appropriate field of any empty subforms. I
need to restrict editing of the serial field in each of the subsequent
subforms so that the serial relationship to the first subform is maintained
(if the user wants to change the position in the series, they would simply
re-select in the serial field in the first subform. Upon leaving any subform
or the form, I want the data (even if the only information provided was the
serial data in its field in each record) saved and update the subform related
table.
I know that is a long description but it gets to the issues. I suspect that
what I am really trying to get to is a query that is called upon entry into
the serial field in the first subform that tests the related table for serial
records 1 through 4, populates the records appropriately. With my over-long
description, someone may see an easier path.
Thoughts? Suggestions? Directions (any except "give up" accepted)? All
appreciated.
Sleepless in Salem
before permitting the entry of new data in the subforms.
If this is trivial, I apologize. I feel like I am tantalizingly close to
working through this problem but I am not quite there and I am burning a lot
of time getting to the next step. If the problem wasn't central or not
repeated in the project, I wouldn't ask for help. I have most of this
working but I am not able to limit/restrict/control data in the form as much
as I need. Thanks in advance . . .
In a form (containing what I think of as 'serial' subforms - each identical
subform representing a record or potential record in a second related table
and each subform selected based upon serialized information from a common
field - if each record weren't so large or so easily comprehended in vertical
format I would use something more like a customer-work order table-linking
form and I don't think I want all of the horsepower and
user-driven-variability of a pivot-table), I need to display a table of
relatively static information. I want to select a non-editable record based
upon a field and have it populate a few additional fields for display only.
I need the data in that selected record to be used to drive the selection of
records for display in the subforms (with each subform tied - locked? - to
the form's data) so that, while in the subform, the data in the common fields
cannot be changed. Having accomplished selecting and populating the form
data, I want to move to the first subform into a specific field (the
identifying field for the serial nature of the records and permit a selection
from a drop down list. Upon selection, I need to query the data to determine
if a record (and one or more of the next 3 in series) already exists in the
table displaying those that already exist in the appropriate subform and
putting the serial data in the appropriate field of any empty subforms. I
need to restrict editing of the serial field in each of the subsequent
subforms so that the serial relationship to the first subform is maintained
(if the user wants to change the position in the series, they would simply
re-select in the serial field in the first subform. Upon leaving any subform
or the form, I want the data (even if the only information provided was the
serial data in its field in each record) saved and update the subform related
table.
I know that is a long description but it gets to the issues. I suspect that
what I am really trying to get to is a query that is called upon entry into
the serial field in the first subform that tests the related table for serial
records 1 through 4, populates the records appropriately. With my over-long
description, someone may see an easier path.
Thoughts? Suggestions? Directions (any except "give up" accepted)? All
appreciated.
Sleepless in Salem
before permitting the entry of new data in the subforms.