refresh subform field (1 Viewer)

idxyz

New member
Local time
Today, 04:52
Joined
May 18, 2020
Messages
24
My access database subform is bounded to a table with a field called Fieldx.
In the keypress property of the subform with Fieldx, VBA updates the table's Fieldx to a different or same value.
Within the same VBA how to refresh the subform Fieldx after the table's Fieldx update?. DoEvents at the end of the VBA module would work?.

need to update:
MainForm1->SubMainForm1->Fieldx
 

June7

AWF VIP
Local time
Today, 03:52
Joined
Mar 9, 2014
Messages
5,472
Post your code that updates field.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 19:52
Joined
May 7, 2009
Messages
19,244
you can directly assign value to Fieldx in code, then save the record

docmd.RunCommand acCmdSaveRecord
 

Users who are viewing this thread

Top Bottom