How to control Date entry 'format' into unbound field on a Form ?

[MyEmailList]

We want to create a popup form to allow the client to enter some
data...

So we have the primary form and a button control that opens the popup
form

The popup form has these fields

Field_1 = A Future Date
Field_2 = bla bla
Field_3 = more bla bla

Once the popup form is closed we want to add the data to the underling
primary form (and the table it is bound to)

(Then the data can not be changed by the user)

How can we control the format of the date the user enters into the
unbound field on the popup so that it will actually be treated by a
date once the client closes the popup form and we put in the table?

thanks for any help.

Mel

 

[John W. Vinson]

How can we control the format of the date the user enters into the
unbound field on the popup so that it will actually be treated by a
date once the client closes the popup form and we put in the table?

Probably the two simplest ways are to use a Combo Box based on a table or
query of valid dates (e.g. a query on a date table returning only dates in the
future, if that's what's needed); or a Date Picker control. One comes builtin
with A2007, and there are examples readily available for earlier versions.

John W. Vinson [MVP]