updating a date field when a yes/no is checked

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I have 2 fields that I want to be dependent on each other. The first one
is a yes/no. the second is a date. So when the user clicks on the checkbox,
i want the date to fill in automatically.
Can this even be done? I know it can be done on a record change, but I am
just not sure
Thanks in advance for any help
 
Casandra,

You sure can. Just create an AfterUpdate event for your checkbox. Make it
something like this

If Me.chkBox = -1 Then
Me.DateField = 'insert whatever you wanted for your date here
End If

HTH

Aaron G
Philadelphia, PA
 
This could be placed in a query or control source for a text box.

iif([yes/no field]=yes, date())

This would return todays date in the field or text box you want it in.

Research iif statments and there structure.

This is only one of many solutions to what you may be looking to accomplish
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updating tables when you input new data 0
How to update a Yes/No fields when other Yes/No fields change 8
Date Field base on yes or no 3
Count multiple yes/no field in a query 4
Check Box or Yes/No fields 3
Yes/No Fields 12
Check if a date exists in a record 1
update date field base on a dropdown 1

Back
Top