[dba-Tech] Subform requery

Oh heck, forget it. Just a common-or-garden mistake on my part. Sorry if I woke
anyone up.
 
Andy
 

On 25 August 2010 at 15:53 Andrew Lacey <andy at minstersystems.co.uk> wrote:

> Oh and there are no linking master/child fields
>  
> -------------------------------
>  
>
> 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
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com