[AccessD] Subform requery

If I recall my cranky Access correctly, unbound comboboxes don't
trigger afterupdate events ... or am I getting confused with .Net?

Charlotte

On Wed, Aug 25, 2010 at 6:51 AM, Andrew Lacey <andy at minstersystems.co.uk> wrote:
> 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
>