non table values

[Dennis Wolf]

I would like to query a database regarding entries that appear after a
certain date.
I would prefer to have a date picker embedded in a form to choose this date
and then be able to open another form from a query that will give me all the
records that occur after that chosen date.
I dont want the chosen date to be a record though (it should not appear in
the table) but a value that can be changed regularly.
please help
Thanks
Dennis

 

[Lynn Trapp]

1. Create a form with an unbound text box for your date parameter.
2. Make that text box a criteria in the query that is the recordsource for
the second form
3. Add a button to the parameter form that opens the second form.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Dennis Wolf]

How do I refer to the unbound textbox (a date picker) in the criteria if it
doesnt have a control source?
Dennis

 

[John Vinson]

How do I refer to the unbound textbox (a date picker) in the criteria if it
doesnt have a control source?

By its name:

=Forms![NameOfForm]![NameOfControl]

Its control source is completely irrelevant.

John W. Vinson[MVP]