Data copying based on button selection

[FOE2272]

I am working on an Access DB that has a form with 8 radio buttons.

The customers are those who bid on a project.

each customer has the following information:

Company
Contact
Adress
City
State
Zip
Phone
Fax

I want to be able to select only one customer with the buitton and have the data for that customer only be automatically copied to other fields within the same table. I realize this is redundant information but, the data sometimes the data is used for all of the customers and sometimes it is used for only the one customer that got the contract

Example of the fields:

Customer 1:
Customer 2:
Customer 3:
Customer 4:
Customer 5:
Customer 6:
Customer 7:
Customer 8:

Let say Customer 5: got the contract, so I click the radio button next to Customer 5:.

I want the all the data for Customer 5: to go to the Customer Sold: fields.

Customer Sold Company:
Customer Sold Contact:
Customer Sold Adress:
Customer Sold City:
Customer Sold State:
Customer Sold Zip:
Customer Sold Phone:
Customer Sold Fax:

[MMcCarthy]

I am working on an Access DB that has a form with 8 radio buttons.

The customers are those who bid on a project.

each customer has the following information:

Company
Contact
Adress
City
State
Zip
Phone
Fax

I want to be able to select only one customer with the buitton and have the data for that customer only be automatically copied to other fields within the same table. I realize this is redundant information but, the data sometimes the data is used for all of the customers and sometimes it is used for only the one customer that got the contract

Example of the fields:

Customer 1:
Customer 2:
Customer 3:
Customer 4:
Customer 5:
Customer 6:
Customer 7:
Customer 8:

Let say Customer 5: got the contract, so I click the radio button next to Customer 5:.

I want the all the data for Customer 5: to go to the Customer Sold: fields.

Customer Sold Company:
Customer Sold Contact:
Customer Sold Adress:
Customer Sold City:
Customer Sold State:
Customer Sold Zip:
Customer Sold Phone:
Customer Sold Fax:

Using radio buttons is a bad idea and will only complicate matters. Look at using a listbox or combobox instead and check out this tutorial.

Example Filtering on a Form