update check box

[Guest]

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

 

[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

 

[John O. Graybill]

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

 

[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

 

[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

 

[Guest]

Thank you Larry, that worked great!