create an option button in access that only updates 1 record--not

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a form in place and I am trying to add fields to the design view. I
would like to work with the option button. For instance, I want to create the
below fields.

Red
Blue
Green

If a client only likes Red, I select Red. If I client likes Blue and Red
then I select both. However, when I do this all of the records are changed to
reflect this. I just want to be able to update one record without having all
of the records changed because I may need to select a different option for
another client.

I hope I made sense and that someone can assist me with this. Thanks.
 
If a control is Unbound on a continuous form, it can have only one value
which will display on all records.

You must bind your option buttons to the Red, Blue, and Green fields in the
RecordSource underlying your form. To do this from form design view, choose
View, Properties to display the Properties window, click on the Data tab, and
set the ControlSource property to the name of the corresponding field.

Hope that helps.
Sprinks
 
The reason that is happening is because you don't have the colors bound
to a field in your table. You would need to have a place to store the
color information to accomplish what you are trying.
 
Sprinks,

Thank you very much. It worked! I have been struggling with that for a while
now and it feels good to have that accomplished.

When I view my table data and look at the columns with the colors I chose
while adding the information in my form there is a -1 in the cell of the
color I chose. Do you know how to get that -1 into an X mark?

Thanks again :)
 
Jeff,

Thanks for your help. I got it to work. I was struggling with that for a
while. I appreciate your response.

I have one another question, I filled out the information in my form and
chose a color for the client's preference and then I went back into my table
data and I noticed there was a -1 under the color I selected for a client. Is
there a way to make that -1 into an X mark?

Thanks again for your time!
 
In the design of the table, select your color field and then click the
lookup tab down below. It is probably set to Text Box. Change it to
Check Box and your values will display as a checked box for True and a
blank check box for false.
 
Jeff,

Thank you so much for your time and help. Everything is running smoothly.

Take care!
 
Back
Top