To filter or not to filter

  • Thread starter Thread starter Lasse T
  • Start date Start date
L

Lasse T

Hello !!
I have made a time booking table with a record for each day with date and
weekday and it will work until year 2015.
Then i made a form with two buttons so I can move thrue the dates forwards
and backwards. When i open the form I want it to open on todays date so I
used a filter on todays date....... Hmmm. Great, but now my buttons wont
work sins the form is filtered. If I remove the filter it jumps to the first
date in the table. Then I made a query that only shows records where date
=todays date. Now I can move thrue dates with my buttons but of cource not
before today.

Is there a way to open the form on todays date and still be able to move
backwards and forwards with the buttons?

Thanks in advance.

Lasse T
------------------
 
Lasse,
Check out the OpenArgs Property (Example) in Help. It shows how to open a
form to a particular record without filtering.
hth
Al Camp
 
Back
Top