K
Ken Miller
I have a form that tracks personnel will be leaving my command sometime in
the future. One combo box let's you choose a name to bring up their record.
Second combo box allows you to change their status, one of five choices
(prospective gain, prospective loss, onboard, transferred, orders cancelled).
The form is linked to a query that brings up personnel that are listed as
prospective loss.
My problem is that when I select a different status, the form won't remove
the record from the query, even when I go out of the form and then return.
Is there any way that I can get the form to update the query automatically by
removing the record while I'm still in the form?
the future. One combo box let's you choose a name to bring up their record.
Second combo box allows you to change their status, one of five choices
(prospective gain, prospective loss, onboard, transferred, orders cancelled).
The form is linked to a query that brings up personnel that are listed as
prospective loss.
My problem is that when I select a different status, the form won't remove
the record from the query, even when I go out of the form and then return.
Is there any way that I can get the form to update the query automatically by
removing the record while I'm still in the form?