Update date text field from several combo boxes

[zan]

I've searched for this everywhere but I haven't yet found a solution, even though I'm sure it should be pretty simple.

I have 2 combo boxes: cboMonth, cboDay
and a text field: txtYear

cboMonth has values: Jan-Dec
cboDay has values: 1-31

After selecting the combo boxes and entering the year, I want the result to be displayed in a text box, with the format of Long Date.

How is this accomplished?

Thanks for any help!

 

[RuralGuy]

Any particular year? Have you looked at the DateSerial() function?

 

[zan]

Thanks!

The dateserial() function works just fine, but I've encountered another problem.

What I actually want to enter is a birthdate.

Right now the text box gathers the values from the 2 cbo boxes and text box and then stores the value into the birthdate field in my table, but since the cbo boxes and text box is unbound, they cannot show the stored birthdate when I navigate through the records.

So can I get the 2 combo box and text values to concentuate into a birthdate and then store it into the birthdate field in the table(tblStudents)?

(My form is bound to tblStudents)

 

[RuralGuy]

Have you considered using a pop up calendar instead?

 

[zan]

Thanks RuralGuy!

In my search for calendars I found this
http://fontstuff.com/access/acctut13a.htm
which was exactly what I wanted!

 

[RuralGuy]

Great! Thanks for posting back with your solution.