I can't seem to get my form to requery, and honestly am surprised I am hung up on this.
I have a continuous form that has fields that need to be hidden and unhidden depending on data in that record. So after they update a record, a field may be hidden or unhidden (technically, just a lookup field).
I tried requerying the individual field with:
DoCmd.Requery "txtPage"
It doesn't give an error, but doesn't work either.
I tried requerying the entire form with different variations, all of which throw errors:
DoCmd.Requery "frmTOCPageMange"
or
frmTOCPageMange.requery
or
Forms![frmTOCPageMange].requery
or
Dim control1 as control
control1 = Forms![frmTOCPageManage]
control1.requery
Any ideas?
I have a continuous form that has fields that need to be hidden and unhidden depending on data in that record. So after they update a record, a field may be hidden or unhidden (technically, just a lookup field).
I tried requerying the individual field with:
DoCmd.Requery "txtPage"
It doesn't give an error, but doesn't work either.
I tried requerying the entire form with different variations, all of which throw errors:
DoCmd.Requery "frmTOCPageMange"
or
frmTOCPageMange.requery
or
Forms![frmTOCPageMange].requery
or
Dim control1 as control
control1 = Forms![frmTOCPageManage]
control1.requery
Any ideas?