problem to requery subform data (1 Viewer)

eugzl

Member
Local time
Today, 12:17
Joined
Oct 26, 2021
Messages
125
Hi All.
The fInventory parent form has Tab Control where I located the fDeviceSubForm and button which call child form to create a new record. All controls located in detail section. When click Save button a new record successfully saved. But the code line:
Code:
Forms!Form_fInventory!fDeviceSubForm.Requery
to requery data of subform return error return error message
DeviceFormErr.png

How to fix the problem?
Thanks
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 12:17
Joined
Feb 19, 2002
Messages
43,233
Try:

Forms!Form_fInventory!fDeviceSubForm.Form.Requery

That should get you to the properties of the subform.. There are places where you can get away without the .Form and others where you can't.
 

eugzl

Member
Local time
Today, 12:17
Joined
Oct 26, 2021
Messages
125
Try:

Forms!Form_fInventory!fDeviceSubForm.Form.Requery

That should get you to the properties of the subform.. There are places where you can get away without the .Form and others where you can't.
Thanks a lot
 
Last edited:

Users who are viewing this thread

Top Bottom