Access 2016 new table added - forms link to old one

[Bossforum930]

I have TWO tables in my ACCESS DATABASE.



For the "new year" I added a NEW TABLE, but, when I click on FORMS, it enters data in the OLD table, not the new one.

How do I fix this?

I hope I don't have to create new FORMS and REPORTS for the NEW TABLE.

Can't I just tell the program which TABLE to enter data when using those FORMS and REPORTS?

Thanks,

[ranman256]

Why are you entering in a new table?
it all should go into the same table ,then you can pull data from any date.

[Bossforum930]

Why are you entering in a new table?
it all should go into the same table ,then you can pull data from any date.

Now that I think of it, sure, I could do that.

1) Can I copy the info I already have in the NEW table to the OLD table or do I have to manually enter the new information?

2) I could ALSO do the "old" make a change in the Original Table, save it under another name and create a NEW file with a new name with all the forms and reports there as well, but I thought I could have it all in one file. I just wanted to separate the years, if possible.

THANKS.

[davegri]

Sounds like you've be affected by the Name Autocorrect option.
The name AutoCorrect feature can track name changes for you, and can automatically correct the names of forms, reports, tables, queries, fields, or controls, such as text boxes.
So, when you changed the name of the existing table, Access accommodated the change and adapted itself to the new name.
See this link:
https://support.office.com/en-us/art...4-a93c10a9d98b

[Bossforum930]

Sounds like you've be affected by the Name Autocorrect option.
The name AutoCorrect feature can track name changes for you, and can automatically correct the names of forms, reports, tables, queries, fields, or controls, such as text boxes.
So, when you changed the name of the existing table, Access accommodated the change and adapted itself to the new name.
See this link:
https://support.office.com/en-us/art...4-a93c10a9d98b

Hi and thanks for the reply.

I didn't change the name of the existing table. What I did was COPY and PASTE a new TABLE, wiping out the old data and leaving only the new data for that YEAR (or table). But the FORMS and REPORTS didn't come with it.

For the time being, because of how much I do or DON'T have to use this, per someone else's advice, I dumped the new table and now have EVERYTHING in one table.

If someone can figure out how to bring the FORMS and REPORTS I created for the original table into a new one, without having to reconstruct it again, then, that would be nice, but, it works for now.

THANKS.

[Bossforum930]

I took your advice and moved the NEW data from the NEW table into the original table and deleted the NEW table.

Maybe I might need a report covering multiple years, so we will leave it as ONE table and see what happens.

Still wondering IF when you create a NEW table, you can bring your old forms and reports with you, versus having to reconstruct them for a NEW table.

Thanks again for the inspiration.

[davegri]

A bound form or report draws it's data from the source specified in the recordsource property.
That source can be:
1. A table name like "tblProducts"
2. A query name like "qProducts"
3. Or an SQL string like "Select ProductID, Product from tblProducts".

1 and 3 name the table directly.
2 uses the table name within its SQL syntax.

You can adjust these names to use whatever source names you wish.

[Bossforum930]

Thanks. I'll try and do some investigating.