Copy text in subform (1 Viewer)

theinviter

Registered User.
Local time
Yesterday, 22:45
Joined
Aug 14, 2014
Messages
237
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

I’m here to help
Staff member
Local time
Yesterday, 22:45
Joined
Oct 29, 2018
Messages
21,358
Not sure about that error message, but the syntax is typically something like:


Forms!MainFormName.SubformContainerName.Form!ControlName
 
Last edited:

theinviter

Registered User.
Local time
Yesterday, 22:45
Joined
Aug 14, 2014
Messages
237
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’m here to help
Staff member
Local time
Yesterday, 22:45
Joined
Oct 29, 2018
Messages
21,358
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

Registered User.
Local time
Yesterday, 22:45
Joined
Aug 14, 2014
Messages
237
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 name:patient_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

I’m here to help
Staff member
Local time
Yesterday, 22:45
Joined
Oct 29, 2018
Messages
21,358
its big size cant attache.

the form name:patient_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

I’m here to help
Staff member
Local time
Yesterday, 22:45
Joined
Oct 29, 2018
Messages
21,358
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

Registered User.
Local time
Yesterday, 22:45
Joined
Aug 14, 2014
Messages
237
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
 

Users who are viewing this thread

Top Bottom