Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2015

    Unanswered: Timestamp on main menu form


    I have a main menu form from which I can enter 3 different forms. I am in a process of making a time stamp for each of those 3 forms.
    So far I have created date/time fields in all 3 tables with default value Now(). When i create the new record the time stamp works perfectly.

    Now what I want to do is to, show these time stamps in 3 different text boxes on the main menu form, but only for last entry. Is this possible?

    Attached are the pictures of main menu and table with time stamp
    Click image for larger version. 

Name:	main menu.JPG 
Views:	6 
Size:	56.4 KB 
ID:	16285
    Click image for larger version. 

Name:	timestamp.JPG 
Views:	3 
Size:	72.1 KB 
ID:	16286

    Best regards

  2. #2
    Join Date
    Apr 2014
    Provided Answers: 32
    txtBox = DMAX("[timestampField]", "table")

    (unless you are talking about the form, then no. Once you look at the form, you change the stamp.)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts