I'm using a form to populate a table called tblPhotoAlbums.
Fields are:
PKid
Photographer (id from another table)
Volume
Date
On the form, I'm using Date Picker, but I hate having to backtrack several years (even decades).
I'd like the Date Picker to default to a particular year and month - depending on what the user inputs for Photographer and Volume.
I was thinking I could use the On Enter event for the Date text box.
eg,
If cboPhotographer = 1 and cboVolume = 1 Then
txtDate.defaultvalue = #10/1/1962#
End If
But the above doesn't work. Not sure why. I still get the Date Picker opening to May 2013.
Any suggestions ?
Fields are:
PKid
Photographer (id from another table)
Volume
Date
On the form, I'm using Date Picker, but I hate having to backtrack several years (even decades).
I'd like the Date Picker to default to a particular year and month - depending on what the user inputs for Photographer and Volume.
I was thinking I could use the On Enter event for the Date text box.
eg,
If cboPhotographer = 1 and cboVolume = 1 Then
txtDate.defaultvalue = #10/1/1962#
End If
But the above doesn't work. Not sure why. I still get the Date Picker opening to May 2013.
Any suggestions ?