I am using Microsoft Access 2013 as the frontend and SQL Server 2012 as the backend of my application.
When my form opens, it opens to a new record and the subform shows no values.
If I lookup an existing record and then try to enter a new record, the subform shows the values of the record which I looked up.
I have the "Link Master Field" and "Link Child Field" set to the proper values.
I tried to Refresh, Repaint and Requery the subform.
Please see the attachment.
I do not have this issue when the backend is an Access database.