|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 20th, 2009, 12:57 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
on click = yes
Hi
I would like the value of a yes/no field to change to yes on click of this field in a form then update the value of a date field in the same form to todays date. Can anyone help with the code for this:? Regards Colin 
|
|
#2
June 20th, 2009, 01:53 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
on click = yes
What if the user wants to unclick the checkbox?
To always have a click mean "yes": Private Sub NameOfCheckboxControl_Click() Me.NameOfCheckboxControl.Value = True Me.NameOfDateField.Value = Date() End Sub -- Ken Snell MS ACCESS MVP http://www.accessmvp.com/KDSnell/ "cjgav" wrote in message news  Hi I would like the value of a yes/no field to change to yes on click of this field in a form then update the value of a date field in the same form to todays date. Can anyone help with the code for this:? Regards Colin
|
|
#3
June 20th, 2009, 06:08 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
on click = yes
In message , Steve
help_available_at_very_reasonable_rates@contactme .com writes Put the following in the click event: Me!NameOfYesNoField = "Yes" You may prefer Me!NameOfYesNoField= not Me!NameOfYesNoField This causes the field to toggle back to No if the field is clicked again. -- Bernard Peek
|
|
#4
June 21st, 2009, 09:55 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
on click = yes
Hi Ken
That works fine . Thanks for that. "Ken Snell [MVP]" wrote: What if the user wants to unclick the checkbox? To always have a click mean "yes": Private Sub NameOfCheckboxControl_Click() Me.NameOfCheckboxControl.Value = True Me.NameOfDateField.Value = Date() End Sub -- Ken Snell MS ACCESS MVP http://www.accessmvp.com/KDSnell/ "cjgav" wrote in message news Hi I would like the value of a yes/no field to change to yes on click of this field in a form then update the value of a date field in the same form to todays date. Can anyone help with the code for this:? Regards Colin
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
