I finally got my weather database back and working after a round of updates stopped it working.
Anyway, I have added 6 months of calc sheets, at 1 per month, to the tables in base. So I now have a table for Jan2018 upto June2018.
Previously the data I entered in a form was added to the main tblWXLeedsdata table, and it was that table which was used by the form.
I have created queries for each of the 6 new tables, and I cannot remember how the information was added to the main tblWXLeedsdata table. I want to now use the form to insert or add data, but when I open the form , it has the last date as 1/11/2017. No data for 2018 is in the main tblWXLeedsdata table.
Thanks