I have a new database. I've imported data from an Excel 2013 spreadsheet to a Table (Contact) & obviously not being, it would appear, at all proficient I seem to have caused an issue with 'pulling up' data stored in the tables via various forms. This issue is not limited to the Table I appended the data to and seems to impact on the Relationships on a number of tables. It would appear that when I attempt to pull up data from a Table(s) via a dropdown combo box in a form it now only seems that a blank form is 'recovered' albeit the code is still correct (unchanged). I have noticed that when I access the table directly there is now a COLUMN with a + sign at the start of each record. When you depress the + sign it 'pops-up' the relationship table, not the whole table but a NEW Record blank line. I can only think that I have changed the format of my Access database. I have made this assumption as when I have accessed previous databases since this is also happening to them., Incidentally, I cleared out ALL data in the hopes that in starting again this would fix the issue. By the way the Excel spreadsheet was virus checked and import was to a new table (since removed and then Appended to the Contact Table.
I know that someone will have the answer as would have come across this before but I can't find the 'fix'.
With much thanks.