[AccessD] Subform requery

Hi Andy,

IIRC, clear the recordsource, then reset it
Me.Sub.Form.RecordSource = ""
Me.Sub.Form.RecordSource = strSource

Michael R Mattys
Business Process Developers
www.mattysconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andrew Lacey
Sent: Wednesday, August 25, 2010 9:52 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Subform requery

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