T
Ted
i have seen some contributions discussing the duplication of main form and
related sub-form records but not one that (to this newbie) tackles the vexing
hurdle under study.
allen browne generously cuts and pastes a boiler plate slice of code that
probably means a lot more to others than to myself which tackles (i would
suppose) the thornier and more general issue of copying main AND related
records.
can somebody donate some bandwidth to the "simpler" issue i wish to raise.
to round things out, some details....
main_form's called "Treatment and Toxicity Form"
sub_form_a's called "Protocol Medications"
sub_form_b's called "Adverse Events (child)" <--- THIS IS THE ONE HAVING
DATA TO BE DUPLICATED ONTO A NEW RECORD!! IT's RECORD SOURCE HAS SAME NAME
AS FORM,
PK comprises 5 fields:
below are name (type in parenthesis), ......
patient_number (#), cycle (#), ae description (txt), subtype (txt), onset
(date/time)
there is a listbox called "Continuing" which is a "Yes"/"No" response taker
on this form. when it's coded "Yes" a cmdbtn named "Duplicate" causes it to
be enabled and there let the user's clicking it actuate the code that
duplicates the record.
btw, i've tried the less elegant cmdbtn wizard which seems to work fine
until you try and scroll/leave the active record at which point it tells you
that the input mask "00/00/00" specified for (1 or more) date fields is
getting in the way (probably because they're displayed using the "Medium
Date" format??).
at any rate, suffice it to say, a bit of bandwidth'd be appreciated at this
point.
thanks for any in advance!
related sub-form records but not one that (to this newbie) tackles the vexing
hurdle under study.
allen browne generously cuts and pastes a boiler plate slice of code that
probably means a lot more to others than to myself which tackles (i would
suppose) the thornier and more general issue of copying main AND related
records.
can somebody donate some bandwidth to the "simpler" issue i wish to raise.
to round things out, some details....
main_form's called "Treatment and Toxicity Form"
sub_form_a's called "Protocol Medications"
sub_form_b's called "Adverse Events (child)" <--- THIS IS THE ONE HAVING
DATA TO BE DUPLICATED ONTO A NEW RECORD!! IT's RECORD SOURCE HAS SAME NAME
AS FORM,
PK comprises 5 fields:
below are name (type in parenthesis), ......
patient_number (#), cycle (#), ae description (txt), subtype (txt), onset
(date/time)
there is a listbox called "Continuing" which is a "Yes"/"No" response taker
on this form. when it's coded "Yes" a cmdbtn named "Duplicate" causes it to
be enabled and there let the user's clicking it actuate the code that
duplicates the record.
btw, i've tried the less elegant cmdbtn wizard which seems to work fine
until you try and scroll/leave the active record at which point it tells you
that the input mask "00/00/00" specified for (1 or more) date fields is
getting in the way (probably because they're displayed using the "Medium
Date" format??).
at any rate, suffice it to say, a bit of bandwidth'd be appreciated at this
point.
thanks for any in advance!