[AccessD] Subform requery

Dan Waters df.waters at comcast.net
Wed Aug 25 11:40:29 CDT 2010


They do trigger AfterUpdate events - but not BeforeUpdate events. 

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Wednesday, August 25, 2010 11:19 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
>

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list