how do i change the check box value in a form to be reflected in m

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

Guest

Say I have created a form. One of the headings read "Type of Damage" and I
have 2 optons to select for that. Option 1 - "Struck" and Option "Damage".

How do I format it:-

1. so some one can only select ONE of the options.
2. When selected, the word (eg. "Struck") is saved in my table instead of a
-1?

Thanks in advance.
 
Hi,

What you could do is to

1) Place an option group control on the form
2) Next place the two radio buttons within the option group control

This should solve the question of how to get someone to only select one option

As for the other one, you might have to put in some VBA code to convert the
value selected for example 1 might be "Struck" and 2 might be "damage"

Hope this helps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do i change the check box value in a form? 2
How to Populate Data from a table to another 0
Select an different index for a form 6
Frontpage 2000 - Going to a new page from a value in a drop-down box 0
Combo Boxes 4
how do I attach a value to a check box in access 2007? 4
PowerPoint Powerpoint Slow Animations 2
Parameter passed from a form to a query 3

Back
Top