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

X

xneiax

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.
 
M

Michael Ng

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
 
Top