A
Achez
I did a look around this group to see if there was already an answer to
this question...a few were similar, but I couldn't see one that
addressed this directly (I'm probably using the wrong search
items...). So if this is a repeat, I apologize. Here's the
situation:
I have a small database that tracks files. I have two similar forms
that feed from individual queries ("Active" and "All"), which
feed from one table ("Files"). What is currently happening is that
once I mark a file to be "Discharged" in the "Status" field,
the record no longer appears in the "Active" form (or query, for
that matter), and only appears in the "All" form and query. I'm
happy with this, but I'd rather automate it somewhat.
The form fields I am concerned with are "Discharge Date" (which is
entered by me, as opposed to being automatically generated) and
"Status" (it's a look-up field with four possible field entries,
"Active", "Discharged", "Pending" and "Issued") from
the "Active" form. I want the "Status" field to change
automatically from "Active" to "Discharged" if today's date
is greater than the date entered in the "Discharge Date" field.
I tried building a statement in the "Active" query, but I just
don't think that I have the language correct. Is anyone able to help
here?
Much thanks,
Achez
this question...a few were similar, but I couldn't see one that
addressed this directly (I'm probably using the wrong search
items...). So if this is a repeat, I apologize. Here's the
situation:
I have a small database that tracks files. I have two similar forms
that feed from individual queries ("Active" and "All"), which
feed from one table ("Files"). What is currently happening is that
once I mark a file to be "Discharged" in the "Status" field,
the record no longer appears in the "Active" form (or query, for
that matter), and only appears in the "All" form and query. I'm
happy with this, but I'd rather automate it somewhat.
The form fields I am concerned with are "Discharge Date" (which is
entered by me, as opposed to being automatically generated) and
"Status" (it's a look-up field with four possible field entries,
"Active", "Discharged", "Pending" and "Issued") from
the "Active" form. I want the "Status" field to change
automatically from "Active" to "Discharged" if today's date
is greater than the date entered in the "Discharge Date" field.
I tried building a statement in the "Active" query, but I just
don't think that I have the language correct. Is anyone able to help
here?
Much thanks,
Achez