Want completed records to disappear and unfinished records to stay on continous form

[MrMedic]

I'm creating a Ward Log for a Safety Database I'm creating for work. The log will help my EMTs keep track of what bed is being used, and how long they have been there. Once a patient is done, and the 'time out' field is filled, I would like to have a button that 'saves' the record and removes it from the form while keeping any other records open that aren't complete yet. The form contains fields for name, bed #, Guest/emp, Time In, Time Out, and a reason for visit. How can I go about doing this? I have attached a picture of the form. In the example, the second record is complete. I would like that record to disappear from the form, leaving record 1 and 3 on the screen. Any help would be greatly appreciated.

[June7]

Remove it by applying filter criteria, such as: WHERE IsNull([TimeOut]).

Use a query with that criteria as the form's RecordSource.

Requery the form in the Save button code.

[Micron]

Use a query with that criteria as the form's RecordSource.

If the form recordsource is a query, it would be Is Null? Then you'd just requery the form rather than filter it?

[June7]

Ooops, yes, should use SQL instead of VBA function.

WHERE [TimeOut] IS NULL

[Gicu]

I would add a combo to the form's header to show All and Active and make the recordsource selection there (as per the previous posts); that way you can easily bring them back in case you need to review\edit them.

Cheers,

[Micron]

I would add a combo to the form's header to show All and Active

Yes but might as well have the 3rd option - All, Active, Complete - or whatever is appropriate.

[MrMedic]

Thank you for the help! I got the form working how I wanted to.

Thank you for the suggestion for the review/edit box, that's a great idea!

[June7]

If you want to make the filter dynamic, then can't put that static criteria in RecordSource SQL.