For over a month I have been using a form/subform to enter new data into a data history table.
I then decided I wanted to have my tables reside in an SQL db, and link ACCESS to the SQL tables. All the queries, forms, etc remained exactly the same. Information typed into the linked tables does immediately show in the SQL tables.
The subform only displays already entered info, it does not bring up a new fresh row for data entry.
Opening the table itself does show a row at the bottom for entering new data, and doing a simple select Query on the table likewise displays a new row for data entry.
The subform has its “Build” query which when run does not display a new data-entry row in my SQL linked ACCESS db, while the same “Build” query in the ACCESS db where the tables are not linked, does display a new row for data entry.