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