update check box

S

sheryl

I posted earlier, but the code I recv'd didnt work.
I have a check box that I would like automatically checked when I update the
field before it. Inputting the permit number, enter, and the check box which
is the next field will be checked. This will eliminate me "forgetting" to
check the box, making the customer look "not current" and getting a late
notice as a result.

Thanks for any help
 
L

Larry Daugherty

Hi Sheryl,

It's me again ...

I don't really know how you've defined your field in your table but, when
referring to a control with a space in it, enclose the control name with
square brackets:

me![Permit renewed]=True (afterupdate event)

HTH
 
J

John O. Graybill

sheryl said:
I posted earlier, but the code I recv'd didnt work.
I have a check box that I would like automatically checked when I update the
field before it. Inputting the permit number, enter, and the check box which
is the next field will be checked. This will eliminate me "forgetting" to
check the box, making the customer look "not current" and getting a late
notice as a result.

Thanks for any help
Click to expand...
 
J

John O. Graybill

Hi Sheryl:

I tested the following code and it worked as you desire:

Text Box Name: tbxPermitNumber

Check Box Name: cbxPermitRenewed


Private Sub tbxPermitNumber_AfterUpdate()

Me!tbxPermitRenewed = True

End Sub

The check box name you showed in your post earlier today had a space in
it. That can cause problems if you try to use it in code.
Hope this helps.

John
 
J

John O. Graybill

Hi Sheryl:

I tested the following code and it worked as you desire:

Text Box Name: tbxPermitNumber

Check Box Name: cbxPermitRenewed


Private Sub tbxPermitNumber_AfterUpdate()

Me!tbxPermitRenewed = True

End Sub

The check box name you showed in your post earlier today had a space in
it. That can cause problems if you try to use it in code.
Hope this helps.

John
 
Top