Link to home
Start Free TrialLog in
Avatar of MrSlithy
MrSlithy

asked on

Date range in Access 2010 Form seems stuck

I ace an Access 2010 form that has a beginning/ending date range entry box that the user can enter dates to show form results within the range. Pretty normal.

The beginning date is set as a default and the ending date is Date()

So normally user can open the form which defaults to the range above, the default opening date and today.

But at some point, that stopped working. I was doing some other things in the form over the last week related to another question here and I might have broke something.

What would be the cause of the form no longer opening with today's date at the ending range. It actually seems to be stuck on several days ago.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
As an aside, from your question it sounds like this textbox is used only for searching/filtering data in a form.

More often than not, such textboxes do not need to be bound to fields in the underlying recordsource.

If you are indeed only using this textbox for searching/filtering try setting it's control source property so that it is blank (unbound).
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MrSlithy
MrSlithy

ASKER

I had to laugh. Accepting your answers hoping you will laugh too. I have a three month calendar on my wall. I was looking at the wrong month. Seriously.

I have spent the last two weeks testing and upgrading various FEs and BEs from access 2003 to 2010 and this has been one of the more imaginative mistakes I have made. lol
Ha!  I think we all have those face-Palm moments.
I have a three month calendar on my wall. I was looking at the wrong month.
Me too.
I am always setting up appointments in the wrong month...

Enjoy your weekend
;-)

Jeff