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
LVL 2
MrSlithyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mbizupCommented:
Check the Control Source property of the textbox.

If it is linked to a date field in the underlying table or query, the value stored in that field will be displayed when the form opens.

The Default Value property (if you have that set to today's date) will only appear under these conditions:
1. If you are on a new/blank record
2. If there is NO value stored in the underlying field specified in the control source
or
3. if the control source property of the textbox is blank
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mbizupCommented:
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).
0
Jeffrey CoachmanMIS LiasonCommented:
Also make sure that you did not accidentally hardcode that previous date into the textbox's control source...
We sometimes do this for testing purposes, ...then forget that we did it.
;-)
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

MrSlithyAuthor Commented:
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
0
mbizupCommented:
Ha!  I think we all have those face-Palm moments.
0
Jeffrey CoachmanMIS LiasonCommented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.