Type text in a switchboard

I

Iowa Joe

Hey, just wanted to know if it is possible to type in a text box on a
switchboard. I have two fields for a data range that I would like to allow
the user to type in. (They can already enter it in using a calendar button
that opens a calendar form, but I would also like to allow them to type it in
if desired). Thanks
 
D

Damian S

Hi Iowa Joe,

If you put a text box control on your form they can type in it. If you want
to use some sort of calendar control, you could have it so that the selected
date from the calendar control populates your text box also.

Is this what you meant?

Damian.
 
F

fredg

Hey, just wanted to know if it is possible to type in a text box on a
switchboard. I have two fields for a data range that I would like to allow
the user to type in. (They can already enter it in using a calendar button
that opens a calendar form, but I would also like to allow them to type it in
if desired). Thanks
Click to expand...

You can have 2 unbound control's on the switchboard form, with their
format property set to a valid data format. Name one StartDate. Name
the other EndDate.

Then in the query (if that is where you are filtering the records) you
would use as criteria on the [DateField]:

Between forms!FormName!StartDate and forms!FormName!EndDate

Note: the form must be open when the query is run.
 
Top