If a text box is empty how do I set the field in the table to 99

[Rick B]

Why not just bind the field to the table and leave the field in the table
blank? You can test for blank in your forms and queries just as easily as
you can test for 99.

If you don't want to do that, then include the field that you want in your
form. Add code on the Before Update event of the form that says...

If Is Null(Me.SomeTextField) then
Me.SomeBoundFieldName = "99"
End If



You could make the bound field visible=no if you don't want the user to see
all this.

 

[pokdbz]

Thanks I will do it this way.

How do you do it for radio buttons in a frame? I tried with the
Beforeupdate of the frame but that didn't work.

Any suggestions?

 

[pokdbz]

I figured it out. Thanks again for the help

Thanks I will do it this way.

How do you do it for radio buttons in a frame? I tried with the
Beforeupdate of the frame but that didn't work.

Any suggestions?