Forum Discussion
Access Help required
Cannot get access to load anything for 2020.. using Windows 7. Any help appreciated. D
When using Access. The forms does not pick up any dates after 31st December. I’ve enclosed a screenshot of one of our forms and the date required (middle of screen) is the last date it will pick up (20th is when we close for Christmas hols). The main table that the forms pick up from has dates well into next year
Hope this helps
Davy1 Screenshots seldom offer any significant clues as to problems like the one you describe. That's because we can't see anything relevant in the screenshot. We see the results only, not the source.
Does the form have a filter applied?
Does the query which provides records to the form have a parameter?
Do you open the form with a filter in place?