Closing Records in Form

I have a table that several associates will enter Tasks. Some of the Task
Names will have the same name but a different form number field. How can I
remove a Task Name from the "open" view once the Task Name has been closed?
How do I make the driver the form number (since that is the different piece)
rather than the Task Name?

Have a field in your table to signify 'not open', something like CloseDate or
Yes/No field. Use that field in query criteria that feeds the form.
--
KARL DEWEY
Build a little - Test a little


"Task Database Nightmare" wrote:

I have a table that several associates will enter Tasks. Some of the Task
Names will have the same name but a different form number field. How can I
remove a Task Name from the "open" view once the Task Name has been closed?
How do I make the driver the form number (since that is the different piece)
rather than the Task Name?

On Fri, 24 Oct 2008 07:15:01 -0700, Task Database Nightmare
wrote:

I have a table that several associates will enter Tasks. Some of the Task
Names will have the same name but a different form number field. How can I
remove a Task Name from the "open" view once the Task Name has been closed?
How do I make the driver the form number (since that is the different piece)
rather than the Task Name?

What does the term "form number" mean? Is that something within the structure
of your table (which you have not posted), or something to do with an Access
Form?

Your question as posed seems to be about your own custom interface, rather
than to Access. Access fields cannot be "closed" or "opened"; Access forms
don't have "form numbers". Please explain, perhaps describing the structure of
your table, and how your tables model "tasks" and "form numbers".
--

John W. Vinson [MVP]

In my table I have several fields. Three of which are

Task Name (Text Field - duplicates allowed)
Form Number (Number Field - no duplicates)
Status (Combo Box - choices are Open or Closed)

Since there can be several records with the same Task Name but different
Form Numbers, I need the query to drive off of Form Number when I choose to
show only Open Tasks. That is what I don't know how to do. When I run the
query if there are several tasks with the same name and all are closed by 1,
it still shows me all the tasks with the same name whether they are opened or
closed - that is why I am thinking I need to draw from form number.

"John W. Vinson" wrote:

On Fri, 24 Oct 2008 07:15:01 -0700, Task Database Nightmare
wrote:

I have a table that several associates will enter Tasks. Some of the Task
Names will have the same name but a different form number field. How can I
remove a Task Name from the "open" view once the Task Name has been closed?
How do I make the driver the form number (since that is the different piece)
rather than the Task Name?

What does the term "form number" mean? Is that something within the structure
of your table (which you have not posted), or something to do with an Access
Form?

Your question as posed seems to be about your own custom interface, rather
than to Access. Access fields cannot be "closed" or "opened"; Access forms
don't have "form numbers". Please explain, perhaps describing the structure of
your table, and how your tables model "tasks" and "form numbers".
--

John W. Vinson [MVP]

Is anyone going to be able to help me with this? Please - thanks!

"Task Database Nightmare" wrote:

In my table I have several fields. Three of which are

Task Name (Text Field - duplicates allowed)
Form Number (Number Field - no duplicates)
Status (Combo Box - choices are Open or Closed)

Since there can be several records with the same Task Name but different
Form Numbers, I need the query to drive off of Form Number when I choose to
show only Open Tasks. That is what I don't know how to do. When I run the
query if there are several tasks with the same name and all are closed by 1,
it still shows me all the tasks with the same name whether they are opened or
closed - that is why I am thinking I need to draw from form number.

"John W. Vinson" wrote:

On Fri, 24 Oct 2008 07:15:01 -0700, Task Database Nightmare
wrote:

I have a table that several associates will enter Tasks. Some of the Task
Names will have the same name but a different form number field. How can I
remove a Task Name from the "open" view once the Task Name has been closed?
How do I make the driver the form number (since that is the different piece)
rather than the Task Name?

What does the term "form number" mean? Is that something within the structure
of your table (which you have not posted), or something to do with an Access
Form?

Your question as posed seems to be about your own custom interface, rather
than to Access. Access fields cannot be "closed" or "opened"; Access forms
don't have "form numbers". Please explain, perhaps describing the structure of
your table, and how your tables model "tasks" and "form numbers".
--

John W. Vinson [MVP]