Hide record

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I would like to make a button on a continuous form next to
each record.
When one presses it the current record should become
invisible or gone from the form (but not deleted from the
source table).
Next time when someone opens the form the record should be
there again.
Is it possible?
 
Michael said:
I would like to make a button on a continuous form next to
each record.
When one presses it the current record should become
invisible or gone from the form (but not deleted from the
source table).
Next time when someone opens the form the record should be
there again.
Is it possible?
Click to expand...

You would essentially have to keep doing a "filter excluding" on the
primary key for that row and then make sure the filter is not saved when
you close the form. The built-in filter options will do this for you
already and by default they are accumulative. If I apply a filter to
exclude [PK]=1 and then apply another filter to exclude [PK]=5, the filter
now excludes both 5 and 1. When you apply a filter on your own you would
have to do the same thing which might get a bit complicated if you also
have other filters already in place.
 
Back
Top