Re: Connecting a Check Box with a date Field?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



JR

Tables store data, forms display it.

NOTE: the following is predicated on the assumption that you are using a
form for data entry. Your ARE using a form, right?!

In the checkbox's AfterUpdate event, add code to "push" the current date
into the date control. If you only need the date, use Date() ... if you
need date & time, use Now().

Good luck

Jeff Boyce
<Access MVP>



"JR" <JR@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2C0FFEFD-F6F8-407F-BBB4-075A085ABA2F@xxxxxxxxxxxxxxxx
> Is there a way to connect a check box, so when I put a check in it, it
> automatically fields in the date with the current date ??
> --
> "JR"


.



Relevant Pages

  • Re: converting look-up fields
    ... The tables in a database are to store data and to maintain the data's ... They do not exist to display or directly enter data directly. ... have to check each place the name occurred and fix it. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Validation rule between 2 fields
    ... Tables store data, forms display it for add/edit. ... data) to add validation code. ... "Amir" wrote in message ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Capitalise first letter
    ... store data, Access forms display (and allow data entry). ... Jeff Boyce ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Count and display entries
    ... I know you do not store data in forms, and I know forms are used to display ... have the number of entries displayed on the form. ... individual entry, and display the number in the "Number of Entries" field. ...
    (microsoft.public.access.formscoding)
  • Re: calculating dates in records
    ... using an unbound control with the record source as a calculation. ... > yea i am using a form to display how many days are left until the next ... I'm imagining a query against the most recent row (requires ... Access tables store data, ...
    (microsoft.public.access.formscoding)