requery a control in a subform 1

[bookenz]

I have a yes/no control in my form called "RequestInitiator" linked to: "tblRequests.Request_Intiated".

"tblRequests.Request_Intiated". is default: "no".

At the start of a new request, some code turns "tblRequests.Request_Intiated" to "Yes" when the request's date & time are set.

in the subform "Requests" I want the "RequestInitiator" to requery and reflect the "yes" case that has just been put in "tblRequests.Request_Intiated".

 

[Eupher]

You should be able to use the Recalc method on the subform or the Requery method on the checkbox control to reflect the data change. See this link for how to refer to subforms and subform controls:

http://www.mvps.org/access/forms/frm0031.htm

HTH...

Ken S.