By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,488 Members | 2,545 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,488 IT Pros & Developers. It's quick & easy.

microsoft access

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Browse more Microsoft Access / VBA Questions on Bytes