[AccessD] Filter Main Form with Subform...

Susan Harkins ssharkins at gmail.com
Tue Jun 24 18:48:29 CDT 2008



> 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'

========Well that's interesting -- it doesn't actually requery the records, 
it just changes the selected record in the subforms?

I wonder -- have you tried another filtering method? Is it just the method 
you're using or will any requery of the main form do this?

I don't know why you can't get a bookmark for the subforms though. I've 
never tried, but have to wonder if it's not a simple syntax problem. Are you 
storing the bookmark as a Static variable?

Susan H. 




More information about the AccessD mailing list