Copy Record Into a Different Form

[Bronwynna]

I am not sure if this is exactly the right area. I am still new to Access
and slowly learning about it's capabilities and just need a little help.

I have 2 forms I created - Mailing List and Clients. What I want to do is
have a button/command that will appear on the mailing list to "convert" to
client, and automatically copy the first name, last name, address, etc into a
new record for a client. This way I can track my mailing list seperate, and
my client form will only show "real" clients.

Is there a way to do this? Thanks for any help!!!

 

[tina]

forget forms for a minute. how is the data stored in the table(s)? suggest
you probably need only one table for "People", with a Yes/No (checkbox)
field named Client. any record where the checkbox is not checked, is
automatically a "Mailing List" person. to "move" a person from mailing list
status to client status, simply put a checkmark in the Client field. you can
choose to display only mailing list records, or only client records, or
both, in a form or report, as needed.

as a new user, you're making a very common mistake - focusing on forms, when
the first steps in database development are to analyze your process, define
the entities, determine their relationships with each other, and create
normalized tables/relationships in the database to support the entities and
their relationships in the "real world". recommend you read the tips at
http://home.att.net/~california.db/tips.html, starting with tips 1 and 2, in
that order.

hth

 

[Bronwynna]

Thanks, I will try that. And thanks, also, for the tips.

 

[tina]

you're welcome

Thanks, I will try that. And thanks, also, for the tips.