[AccessD] Filter Main Form with Subform...

Susan,
 Completely unlinked. It seems whenever you apply a .filter to the main
form, the subforms do something that looks like requerying, and the users
record position is lost in the subform. 

 I ran into this problem years ago when working with A2000, but in that
design I was able to change the way the user selected the records. I cannot
do that with this design, so I really need a better solution than the one I
created...

This, or any variation will cause the subform to 'requery'

  With Me.Parent
    .Filter = "[Customer ID] Like " & Me!CID
    .FilterOn = True
  End With

Thanks for your help!

~Robert





-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, June 24, 2008 6:25 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Filter Main Form with Subform...

> The problem with this approach is it takes a bit of time to complete the
> cycle and re-look up the selected record. Is there a way to keep the 1st
> subfrom from requiring?

======Requerying the second subform requeries the first, even though they're

not linked? Are you sure they're not linked? Or, did I misunderstand the 
problem?

Susan H. 

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