How do I use an inputted field in a form to enter automatically in another

[mctanmar]

Hi All,

Hope you can help. I have a form where I select either "Male" or "Female" via tick box. If male is selected I would like it to automatically enter "he" in my table in another field so I can use this info in a Word template letter.

Thanks in advance
Mark

[ranman256]

1.put an unbound frame, named fraSex, on the form, in it the 2 radio buttons M, F. (M value = 1, F value = 0)
(remember the FRAME gets the value of the radio buttons, not the buttons)

2. put a text box called txtSex, bound to the field and make it invisible.
3. in the AFTERUPDATE event of fraSex, put this code:

sub fraSex_Afterupdate
     if fraSex.value = 1 then
        txtSex = "he"
     else
        txtSex = "she" 
     endif
end sub

[ItsMe]

There may be a better way to approach this. But, you could bind a control to your second field that is within your table. Code behind the form could handle the After Update event of your tick box. I suspect you have created an option group that has two radio buttons. So you would use the name of your option group within the VBA code. Create an After Update event for your option group. Also, you need to understand what the default values for your option group are.

if me.OptionGroupName.value = Something then
me.secondcontrol.value = "He"
else
me.secondcontrol.value = "She"
end if