T
Ted
i hava a form in my a2k app'n called "RECIST Disease Evaluation: Nontarget
Lesions" from which i select a value of "Patient Number". there's a cmdbox on
it which launches a macro which opens a form called "Lesions: Nontarget -
Baseline" which has a matching control called "Patient Number" that is linked
to a combobox. currently, i forcing the users to use the combobox to select
the value of "Patient Number" however if i were using it i would prefer to
have the benefit of a prefilled in value of the "Patient Number", Soooooo...
i wrote this small vba code which i placed on the Form Open event prop'y of
the "Lesions: Nontarget - Baseline" form and here's the error message that
ensues:
"You can't assign a value to this object".
pray tell why not, may i ask.
anyone care to help me straighten this out?
it'd be really appreciated.
Private Sub Form_Open(Cancel As Integer)
LAS_EnableSecurity Me
Me.Patient_Number.Value = Forms![RECIST Disease Evaluation: Nontarget
Lesions]![Patient Number]
End Sub
Lesions" from which i select a value of "Patient Number". there's a cmdbox on
it which launches a macro which opens a form called "Lesions: Nontarget -
Baseline" which has a matching control called "Patient Number" that is linked
to a combobox. currently, i forcing the users to use the combobox to select
the value of "Patient Number" however if i were using it i would prefer to
have the benefit of a prefilled in value of the "Patient Number", Soooooo...
i wrote this small vba code which i placed on the Form Open event prop'y of
the "Lesions: Nontarget - Baseline" form and here's the error message that
ensues:
"You can't assign a value to this object".
pray tell why not, may i ask.
anyone care to help me straighten this out?
it'd be really appreciated.
Private Sub Form_Open(Cancel As Integer)
LAS_EnableSecurity Me
Me.Patient_Number.Value = Forms![RECIST Disease Evaluation: Nontarget
Lesions]![Patient Number]
End Sub