Help stoping code from clearing a box

[tonylpcs]

Hi Everyone,

Can someone please correct this code for me,

It works fine but clears any data i input in the field, I can see why but dont know how to stop it, please can someone tell me where ive gone wrong?

If Combobox3.Value = "Yes" Then
    Me.Textbox22.Value = Textbox30.Value
Else
    Me.Textbox22.Value = ""
    End If

Basicly "Combobox3" is a drop down box that asks if details are the same as above and you select "Yes" or "No"

Textbox 30 is the box i put the persons name in.
what i want it to do is if I slect "Yes" in textbox3 it autofills textbox22 but if i select "no" it put nothing in it and lets me fill it myself.

what is happening is everytime i put somthing in the box because im having to rerun the code as i swich from one record to another it is clearing the box because im telling it to make the value "" but i dont know what it tell it to do to just leave it as it is?

please help me?

thanks

Tony

 

[Shenlung]

If Combobox3.Value = "Yes" Then
     Me.Textbox22.Value = Textbox30.Value 
Else
     Me.Textbox22.Value = Textbox22.Value
 End If

This might work?

 

[tonylpcs]

Thank you,

I think i tryed everything but that!

Easy when you know how,

thank you so much for your help

Tony