Archived not work

[Franka Situmorang]

Hello,

On the member input form, I have a yes no text control, to tick mark if I
want it as inactive/archived. But it does not work. I have put the fiedl in
the query and criteria is NO, but when I test it ticked mark as arhcived, I
still see the record, eventthough I tried to go to next record and returned,
but I still see the record. Can anyone help me?

Thanks in advance

 

[karl dewey]

You either have to close the query and open again or refresh it.
So try closing and opening.

 

[Jeff Boyce]

We aren't there. We can't see your table structure, nor your form design,
nor the SQL of your underlying query(s).

Please provide more information...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Linq Adams via AccessMonster.com]

As Jeff said, you've given us almost nothing to go on, but if you're marking
the record as "archived" you'll have to requery the form for the record to
not show. Simply moving to another record and then back won't do it.