Please Help.....Linking forms??????

[wright305]

I have created a form which contains a subform. The two are linked by a field
"case number". Once you start typing in the subform, it auto fills the case
# field in the subform (works great). Now, I would like to create a button
on the form to open another (3rd) form [Witness ] and autofills the case # in
that form as well. I was told to try creating a button and for the "on click"
use the following:
DoCmd.OpenForm "Add/Update Witness",acNormal,,"[Case #] = " &
Case Number
I did this and it will open the witness form but don't autofill the case #?
Can this be done??

 

[John W. Vinson]

I have created a form which contains a subform. The two are linked by a field
"case number". Once you start typing in the subform, it auto fills the case
# field in the subform (works great). Now, I would like to create a button
on the form to open another (3rd) form [Witness ] and autofills the case # in
that form as well. I was told to try creating a button and for the "on click"
use the following:
DoCmd.OpenForm "Add/Update Witness",acNormal,,"[Case #] = " &
Case Number
I did this and it will open the witness form but don't autofill the case #?
Can this be done??

see my answer in your other thread... you can have multiple subforms.