Switchboard

[PurpleLady]

Hi there - i am such an amateur when it comes to swtichboards. I have
learned that the switchboard wizard is no fun. I like building my own.
Today my concern is using an "unbound" text box to ask for a event date.
When the date is keyed a report is generated for that event.

I have never used an unbound box so i am lost. I looked at a friend's
database and i think i see what to do, but when i try it - goof!

I also want to add a second one that ask for a start date and end date. I've
seen it happen, but not sure how to do it my self.

Any help and encouragement is appreciated.

Thanks - Purple Layd (newbie)

 

[Allen Browne]

See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

Method 2 in that article explains how to use a form with 2 text boxes (for
entering the starting and ending dates) and a command button to open the
report filtered to the dates (if the user entered some.)

The unbound text boxes are not an issue. Just set their format property to:
General Date
so that Access knows what data type they are supposed to hold, and rejects
things like June 31.