Form code auto update fields

[Phil]

i have a form that i use to send out welcome letters and letters for
unconfirmed responses.

What VBA do i need to use to ensure that when i press a button, it
automatically ticks a tick box and adds a date to a date field on the form.

 

[Debra Farnham]

Hi Phil

Something like this should work:

Private Sub NameofButton_Click()

Me.nameofcheckbox = -1
Me.nameoftextbox = #whateverdateyouwant# (If today's date then Date())

End Sub

of course substituting the "Nameof" portion of the VBA to the actual names
of your controls.

HTH

Debra

i have a form that i use to send out welcome letters and letters for
unconfirmed responses.

What VBA do i need to use to ensure that when i press a button, it
automatically ticks a tick box and adds a date to a date field on the

form.

 

[Phil]

Thanks a lot that worked great

Phil

Hi Phil

Something like this should work:

Private Sub NameofButton_Click()

Me.nameofcheckbox = -1
Me.nameoftextbox = #whateverdateyouwant# (If today's date then Date())

End Sub

of course substituting the "Nameof" portion of the VBA to the actual names
of your controls.

HTH

Debra



form.