Nov 04 2019 06:13 AM - edited Nov 04 2019 06:31 AM
Nov 04 2019 07:24 AM
Unfortunately, there's not enough information there to try to offer a suggestion.
What do you mean, for example, by "load anything for 2020"? What are you trying to load? How are you trying to load it? I assume you must have an existing accdb and you want to use that?
Give us the details and someone might be able to help.
Nov 05 2019 08:00 AM
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
Nov 07 2019 09:55 AM
@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?