UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> requery a control on a subform    
 
   
minnesota1972
post Nov 17 2004, 05:39 PM
Post #1

UtterAccess Veteran
Posts: 473
From: Vancouver BC, Canada
Hi

On the 'on current' control of my form, I'm trying to requery a control on the sub form. but I can't figure out the code.
[List] is my form
[Listsub_ClassKid] is my subform
[ckCID] is what I want to requery

On the main form do I use:
Me.[ListSub_ClassKid].[ckCID].Requery
or do I use this it on the 'on current' of the sub form?

John
Go to the top of the page
 
+
Larry Larsen
post Nov 17 2004, 05:44 PM
Post #2

UA Editor + Utterly Certified
Posts: 22,722
From: Melton Mowbray,Leicestershire (U.K)
Hi John
Try:
Me!SubformName.Form!ControlName.Requery

Reference: Refer to Form and Subform properties and controls.
HTH's
(IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)
Go to the top of the page
 
+
minnesota1972
post Nov 18 2004, 03:35 PM
Post #3

UtterAccess Veteran
Posts: 473
From: Vancouver BC, Canada
Hey That's a fantastic reference.

Thanks for the help and the link!

John
Go to the top of the page
 
+
Larry Larsen
post Nov 18 2004, 05:07 PM
Post #4

UA Editor + Utterly Certified
Posts: 22,722
From: Melton Mowbray,Leicestershire (U.K)
Hi John
Your welcome..
(IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 07:19 AM