GetLast

[RustyRick]

As I enter Data into the "Form" I'd like it to give me the last date entered in the "Date" field. this would save data entry time over having to stop and select the "Date Picker" with the mouse. (although I lone the date picker) it is slow. Then I could just keep tabbing over that field greatly enhancing the speed and help avoid a wrong date pick.

Is there a simple solution to that?

 

[MarkK]

Yes, handle the AfterUpdate event of the date's textbox, and set its DefaultValue property to the date that was just entered. Here's sample code ...

Private Sub Date_AfterUpdate()
[COLOR="Green"]'   Sets the default date to the one that was just used[/COLOR]
    Me.Date.DefaultValue = "=""" & Me.Date & """"
End Sub

In this case the name of the textbox is "Date"