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

M

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
 
J

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top