Date box on switchboard

[Guest]

I have created a beginning date box and an ending date box on my switchboard
that the queries will use to specify a date range in the generated reports.
I know to put the following formula in my queries so the queries can read the
date from the switchboard: between [forms]![nameofform]![BeginningDate] and
[forms]![nameofform]![EndingDate]

I cannot enter a date into the boxes on my switchboard. How do I fix this
problem? What should my control source be? I just used unbound text boxes
to form the date range fields... should I have done something else? PLEASE
HELP ME WITH THIS!

 

[Steve Schapel]

MLC,

Can you be more specific about the meaning of "cannot enter a date into
the boxes"? Unbound textboxes is the correct approach. Check the
Enabled and Locked properties of the checkboxes.

 

[Guest]

I inserted two unbound text boxes into the switchboard form, and when i try
to type a date into the box in regular view (or type anything for that
matter) I'm not allowed to enter anything into the field. I checked the
enabled and locked properties, and they are all okay. I didn't "custome
create" the switchboard. I let the computer generate it for me. It this
what is holding me back? Is there a way around this?

MLC,

Can you be more specific about the meaning of "cannot enter a date into
the boxes"? Unbound textboxes is the correct approach. Check the
Enabled and Locked properties of the checkboxes.

--
Steve Schapel, Microsoft Access MVP

I have created a beginning date box and an ending date box on my switchboard
that the queries will use to specify a date range in the generated reports.
I know to put the following formula in my queries so the queries can read the
date from the switchboard: between [forms]![nameofform]![BeginningDate] and
[forms]![nameofform]![EndingDate]

I cannot enter a date into the boxes on my switchboard. How do I fix this
problem? What should my control source be? I just used unbound text boxes
to form the date range fields... should I have done something else? PLEASE
HELP ME WITH THIS!

 

[Steve Schapel]

MLC,

The next thing to check would be the Allow Edits property of the form
itself... should be set to Yes.