microsoft access

[web_djs]

I have two questions. I'm maintaining a contact list in access. I'd
like to have a second table that I'll move the not interested contacts
into. I need to know how to make that happen? Also, I want to have a
button on a form that puts me into a data entry form and I'd like to
bring a couple values from the current form to the new form
automatically... how do I do that?

Norm

[Tom Wickerath]

Why bother moving contact records to a "not interested" table? You can add a Yes/No
datatype field to your existing table, where Yes (checked) means interested and No
(unchecked) means not interested. A query can include a criteria on this field to return
whichever set of records you want from a single table.

This KB article might be useful to you in finding a solution to your second question:
http://support.microsoft.com/default...roduct=acc2000

Tom
__________________________________________________ ______

"web_djs" <dj*******@netscape.net> wrote in message
news:a4**************************@posting.google.c om...

I have two questions. I'm maintaining a contact list in access. I'd
like to have a second table that I'll move the not interested contacts
into. I need to know how to make that happen? Also, I want to have a
button on a form that puts me into a data entry form and I'd like to
bring a couple values from the current form to the new form
automatically... how do I do that?

Norm