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]

Re: microsoft access

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.aspx?scid=kb;en-us;210236&Product=acc2000

Tom
_______________ _______________ _______________ ___________

"web_djs" <djsimmers@nets cape.net> wrote in message
news:a4e7ed0e.0 310241814.5f209 4d0@posting.goo gle.com...

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