[AccessD] Subform requery

Is sub1 the name of the subform or the name of the control that the subform sits in?

It should of course be the name of the control, not that of the form.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andrew Lacey
Sent: Wednesday, August 25, 2010 9:52 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Subform requery

Congrats Jim.
 
Ok to brighten a quiet week here's an actaul honest-to-goodness Access question ("Access, what's that?" I hear you mutter).
 
Using A2K I have an unbound form with some selection fields (2 combos, a check box). The form has a subform which shows certain records depending on what user selects in main form. Simple stuff. Only it doesn't work. In the AfterUpdate of the combos and check box is:
 
me.sub1.form.requery
 
Nothing happens.
 
The subform works. If I change the Recordsource of teh subform to prompt for the info rather than read it from the main form it works. Yet it must recognise the references to the main form because it doesn't ask me for any parameters (which it does, for example, if the main form isn't even open). This is trivial stuff.
I've done it a million times in my old A97 db but I cannot get that subform to respond. Is this an A2k bug or what? Help.
 
Cheers
 
Andy
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com