Copy text in subform

[theinviter]

Hi guys;
I need your help please,
I have a form with sub and subform , when used update the field in sub subform , i wanna the value in subform to get updated ,
i tried this code :
[Forms]![Patient_Information].Form.[pt data1].Printed_By = [Forms]!Patient_Information.Form.STFF_ID2

but got error message ( microsoft access cant find the field 1 refereed to your expression)
please how to solve this.

 

[theDBguy]

Not sure about that error message, but the syntax is typically something like:


Forms!MainFormName.SubformContainerName.Form!ControlName

 

[theinviter]

Not sure about that error message, but the syntax is typically something like:


Forms!MainFormName.SubformContainerName.Form!ControlName

i modified the code as
Forms![Patient_Information].[pt data1].Form!Printed_By = [Forms]!Patient_Information.Form.STFF_ID2


but got the same error message

 

[theDBguy]

i modified the code as
Forms![Patient_Information].[pt data1].Form!Printed_By = [Forms]!Patient_Information.Form.STFF_ID2


but got the same error message

Can help you better if we can see it. Are you able to post a copy of your db?

 

[theinviter]

Can help you better if we can see it. Are you able to post a copy of your db?

its big size cant attache.

the form nameatient_Information
subform name: pt data1
sub subform = diligent
Filed name in subform : Printed_By

so when the user update any date in sub subform then wanna field in subform : Printed_By get updated with
[Forms]!Patient_Information.Form.STFF_ID2.

 

[theDBguy]

its big size cant attache.

the form nameatient_Information
subform name: pt data1
sub subform = diligent
Filed name in subform : Printed_By

so when the user update any date in sub subform then wanna field in subform : Printed_By get updated with
[Forms]!Patient_Information.Form.STFF_ID2.

Can you strip it down to only the bare essentials? For example, just include the form and subform plus the tables they need. Don't need everything else.

 

[theDBguy]

Hi. I didn't test this but try using:


Forms!Patient_Information.[pt data Subform].Form!Printed_By = Forms!Patient_Information.STFF_ID2


Hope it helps...

 

[theinviter]

Hi. I didn't test this but try using:


Forms!Patient_Information.[pt data Subform].Form!Printed_By = Forms!Patient_Information.STFF_ID2


Hope it helps...

i tried but the same error