Re: filtering records in sub-form has problems in a2k

So your code is removing the main form's filter, whereas you want it to
remove the subform's filter?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ted" <Ted@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:82C4EACA-8229-4B4E-AC33-AECD19F95520@xxxxxxxxxxxxxxxx
> the core issue revolves 'round what happens on REMOVING the filter alone,
> allen. it (the code i described early in this thread) seems to work
> successfully in filtering the subform's records. it's when you click on it
> a
> 2nd time to remove the filter that it scoots the user to the mainform and
> the
> first recdord in its underlying control source.


.

Relevant Pages

  • Re: Filter on form
    ... Allen Browne - Microsoft MVP. ... >> - don't filter on this field. ... >> Allen Browne - Microsoft MVP. ... Dim strDelim As String 'Delimiter for type of field. ...
    (microsoft.public.access.forms)
  • Re: Access 2007 filtering issue
    ... Allen Browne - Microsoft MVP. ... particular form the "Filter On Load" property is set to "Yes". ... All I've done is distribute the converted frontend (converted from '97 to ...
    (microsoft.public.access.modulesdaovba)
  • Re: filtering records on nested subform
    ... Allen Browne - Microsoft MVP. ... > things have reverted -- meaning that when i filter the subform (although ... > that happens is the application takes the user to the mainform for the ...
    (microsoft.public.access.formscoding)
  • Re: Filter by Selection on Date fields
    ... your non-American dates. ... Allen Browne - Microsoft MVP. ... When I filter by that selection it's okay when the date is ...
    (comp.databases.ms-access)
  • Re: Modern bikes are rubbish
    ... inaccessible without removing the radiator apparently. ... filter, so ma piece of piss to change. ... Early Hinckley 900 triples - try removing the central pot's spark plug ... Ducati 750/900SS and probably several others - remove rear ...
    (uk.rec.motorcycles)
Loading