date

[skate]

probably a dumb question but how do i display a certain date in a txtbox based on the values of 3 different fields representing day, month, year?

 

[Mile-O]

Assuming that txtCompleteDate is the destination and txtDay, txtMonth, and txtYear are the other three textboxes you can use the following piece of code to create a date in txtCompleteDate.

txtCompleteDate = DateSerial(txtYear,txtMonth,txtDay)

The only caveat being to write code to ensure that each textbox has a value before performing the DateSerial funcion.