[AccessD] Subform requery

Andrew Lacey andy at minstersystems.co.uk
Wed Aug 25 08:51:48 CDT 2010


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


More information about the AccessD mailing list