I've upsized my access database to MSSQL and now I have some problems in my project.
In the subforms where I had a dropdown list with a query as a row source before (with the Access backend), I could had a new record in the subform.
Now that we moved to a MSSql backend, I can't do that anymore. And I've checked that AllowAdd is set to Yes in the properties of the subform.
I've then noticed that if I just put the name of the table upon which the query is based, it is then possible to add a new record...
The trouble is that I had some queries based on several table using join or some queris with some order by clauses and apparently and I have no idea how I could solve this.
I guess (hope) I'm not the only one to encounter this problem. So if anyone of you did, I would really appreciate any advice.