I have a service related database. I have place a text box on a form called "status". The data in the status text box is either "open" or "complete". When the status shows complete, I would like to hide that record. I would also like to place a command button that reverses the procedure and displays all hidden records.
I realize that I could create a query to accomplish this, however I just want to accomplish this only on a form.
Are you saying that you have a TextBox where you have to manually Input the words "COMPLETE" or "OPEN" ??? Why not have a ComboBox or a CheckBox or something to that effect? That would make it easy.
Are you also saying that you want to make that record GoAway as soon as you type either word in it?
As suggested a Query would be a good place to do that along with a CheckBox or something, then you can make the form ReQuery when you check that box and also have the query to not show it again until you either Remove the check or Code it with a CommandButton. If you post a sample I would be glad to try to help you out. It is something simple.