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

Data copying based on button selection

FOE2272
P: 20
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:
May 7 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
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
May 8 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.