Can this be done

[Bob H]

I have a tooling database at work with over 5000 items in it.
I have fields: LastTestDate, NextTestDate, and TestDate in the qryTools.
The TestDate field tells me if the test date is Due, Due Soon or Overdue.
In the database there are many items which are showing as Overdue
because of many reasons: like missing, scrapped or BER.

What I would like to do is to move all the items which are showing as
overdue to a newly created table and from that build a query and form.

Would or could this be achieved from an event for the TestDate field on
the form.

Thanks

 

[Douglas J. Steele]

Why would you want to have multiple tables?

Just create a query on the existing table that just returns the rows of
interest, and use the query wherever you would otherwise have used the
table.

 

[John W. Vinson]

I have a tooling database at work with over 5000 items in it.
I have fields: LastTestDate, NextTestDate, and TestDate in the qryTools.
The TestDate field tells me if the test date is Due, Due Soon or Overdue.
In the database there are many items which are showing as Overdue
because of many reasons: like missing, scrapped or BER.

What I would like to do is to move all the items which are showing as
overdue to a newly created table and from that build a query and form.

Would or could this be achieved from an event for the TestDate field on
the form.

Thanks

Um.... why would you want a new table???

Just base the form on a Query selecting the overdue items.

If you have these three fields (LastTestDate, NextTestDate, TestDate) actually
stored in your table you have a real design flaw: you should only store the
scheduled test date and the actual test date, perhaps in a Testing table
related one to many to the Tools table. Maybe you are doing it this way but
it's hard to tell from your post.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com