Date box on switchboard

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
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?

Steve Schapel said:
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!
Click to expand...
Click to expand...
 
MLC,

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