Re: Removing filter loses bookmark

Whatever you have in the Current event has to be removed.

If you have any code or macro that requeries the form or applies/removes a
filter so that the form returns the the first record, you have a circular
logic problem and you must remove that code.

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

"Kate" <eppstein@xxxxxxxxx> wrote in message
news:%23H2dbukWGHA.3332@xxxxxxxxxxxxxxxxxxxxxxx
Hi, I'm using Access 2003 on XP. My frustration is that I'm trying to
keep the current record
current when a user removes a filter. Instead, the first record of the
recordset is always shown.

I've tried so many different variations of dealing with this that I'm in a
total muddle.

I have a variable that stores the current record's unique ID, so that
it can be returned to after the filter is removed. That, however, fires
the current
event, which resets the first record as the current record all by itself.
I can't figure it out!
If I try to return to it within the current event, that of course fires
the current event! AAAAAHHH!

Does anyone have any suggestions on how to handle this type of navigation?

TIA,
Kate


.

Relevant Pages

  • Re: Display a specific record by clicking an open form button-not
    ... The forms wizard presents a screen with 3 options, ... It doesn't necessarily have to filter out the records, ... It just brings me to the first record on the form. ... I tried a macro, as well, but the macro opens the building form with the ...
    (microsoft.public.access.forms)
  • Re: Removing filter loses bookmark
    ... filter, change the sorting, change the RecordSource, or requery the form. ... the first record becomes the default? ... before I reset the form's recordsource, and then in the ontimer event, I ...
    (microsoft.public.access.formscoding)
  • Removing filter loses bookmark
    ... My frustration is that I'm trying to keep the current record ... the first record of the recordset is always shown. ... it can be returned to after the filter is removed. ... If I try to return to it within the current event, that of course fires the current event! ...
    (microsoft.public.access.formscoding)
  • Re: In Access 2007 why does info disappear?
    ... I did not set a filter. ... As I was entering the next employee name the first record disappeard. ... or the table datasheet? ...
    (microsoft.public.access.gettingstarted)
  • returning value from filtered records
    ... want to do is use autofilter to filter the records on column D but then not ... print columns J & K rather have the value from the first record in J ... As we're dealing with filtered / visible cells here i can't figure out a way ...
    (microsoft.public.excel.misc)
Loading