Calander

[Richard_Marx]

Can someone give me illicit instructions on how to create a user form with a text field that once the user clicks into a pop-up calander is shown on the form and the date selected from the calander is then transferred to the textbox. It would be the case for 2 textboxes, one called hiredDate and one called leftDate.

[rpeare]

I'm sure you mean explicit (clear), not illicit (illegal)

The type of functionality you're looking for wasn't added to Access until access 2007 (Your listed version is 2000). The calendar controls prior to 2007 were clunky to say the least and not always intuitive:

Let's say you have a form with a field named

fldDate

You have an activex control on that form for the calendar control named CalendarControl

you'd have to have this:

Private Sub CalendarControl_Click()
flddate = CalendarControl
End Sub

so even though when you look at the events available for the calendar control the ON CLICK event isn't there it's still programmable as though it were.

[jo15765]

I always use the directions listed here and haven't had any issues with it. Just take note that in the example they rename the combo boxes so they aren't ComboBox0 or whatever default is.
http://fontstuff.com/access/acctut09.htm

[Richard_Marx]

I always use the directions listed here and haven't had any issues with it. Just take note that in the example they rename the combo boxes so they aren't ComboBox0 or whatever default is.
http://fontstuff.com/access/acctut09.htm

I'll give that tutorial a looksee. Thank you for that link.

[Richard_Marx]

I'm sure you mean explicit (clear), not illicit (illegal)

LOL yes, sorry I did mean explicit. Sorry about my mistake and good catch on that.

[Richard_Marx]

from the form textbox hireDate to use this as criteria for a Select query would I use the below syntax to pull the date entry from the form into a query?

([forms]![form1]![hireDate])

[rpeare]

You don't need the () if you're putting it in the criteria of a query.