Re: Combo Box & Null Value (1 Viewer)

[jai kushwaha]

Re: Combo Box & Null Value

hello friends,
I have a form and lots of combo boxes and text boxes. some of text boxes based on combo boxes. the form is working on copy the last record and paste it in new record so you can change it easil. I set text fields based on combo box selection if combo box is "yes" then text boxes visible and enable to type else the disappear ,so in new record if I choose "no" the text field disappear but because this is the copy of last record the text boxes has some value in it. so now the problem is I want to set text boxes to to null or to be clean when I choose "no" in combo box.

is there any solution can someone help me??

thank you in advanced...

 

[arnelgp]

Re: Combo Box & Null Value

on the code (maybe afterupdate) of your combobox that hide/show:

If ((Me.combo.Value) = "No") Then
Me.textBox1.Value = Null
Me.textBox2.Value = Null
...
End If

 

[jai kushwaha]

Re: Combo Box & Null Value

thank you my dear friend its working now one more question there is I am facing the problem with copying and paste append, as I told you my database works on copy last record and paste it in new record. but there is a problem with clipboard and I dont know what to do with it. it encounters error 2226 and 2046.