Vba subform recordsource not updating
When I try to add new record and filling table fields It showing me an error : The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. You have to transform your query in updatable by using table / or linked tables that can be updated! Thanks in Advanced In fact the only thing that I said is that: YOU NEED TO USE AN UPDATABLE SELECT QUERY FOR YOUR SUBFORM /S IF it isn't the case so you have to think how to do your queries updatable! The subform which is located in the form also has properties that you can see them clicking in the respective subform once pressing the right mouse bouton if you are with right handing mouse and choose properties! It is a very strange solution to a very unusual problem. In order to see the Properties sheet that has the above 2 fields, bring up the property sheet of the subform. Click the Data tab, and you'll see the following: I have the same issue. The string is the least memory intensive variable that will hold a sourceobject(a variant will do as well, but will use more memory). In order to see the Properties sheet that has the above 2 fields, bring up the property sheet of the subform. Click the Data tab, and you'll see the following: in the Properties sheet.Please note these are both cascading Combo boxes, and the Child Name combo box has the ID hidden in it.
In the back end the tables are linked by the child ID, this is the primary key in the Studentlist table and a foreign key in the Points table.
I have written VBA code that filters the SQL statements of the subforms based upon the value of the the REV field on the main form.