N Novice1 Registered User. Local time Today, 05:26 Joined Mar 9, 2004 Messages 385 Feb 14, 2016 #1 I cannot update a field in a tabbed form. I tried frmPCSTracker.Controls(Remarks).Value = "whatever" Any help would be appreciated.
I cannot update a field in a tabbed form. I tried frmPCSTracker.Controls(Remarks).Value = "whatever" Any help would be appreciated.
C CJ_London Super Moderator Staff member Local time Today, 13:26 Joined Feb 19, 2013 Messages 17,563 Feb 14, 2016 #2 Remarks need to be in double quotes when referred to in this way - and you don't need .value since this is the default property for the control. You are also not referring to the form correctly. If this code is in frmPCSTracker then all you need is Remarks="Whatever" and if in another form forms!frmPCSTracker.Remarks="Whatever" you might find this link useful as a reference when referring to controls http://access.mvps.org/access/forms/frm0031.htm
Remarks need to be in double quotes when referred to in this way - and you don't need .value since this is the default property for the control. You are also not referring to the form correctly. If this code is in frmPCSTracker then all you need is Remarks="Whatever" and if in another form forms!frmPCSTracker.Remarks="Whatever" you might find this link useful as a reference when referring to controls http://access.mvps.org/access/forms/frm0031.htm
