Hello everybody,
I have a select query that I created to use as a subform in my database. I created a select query to select the primary key from one table (tbl CA Sites) to gather records from another table (tblSite Components)
Since I have created my query I have split the database into a front end and backend application. I can no longer change the information within the select query. Before I split the database I was able to click yes/no boxes, however now it seems like the records are locked. I have created duplicate queries but they also seem to be locked. There is nothing in the query or form properties that states there are record locks. Can anyone tell me how to fix this problem and use my query in an unlocked subform.
I have a select query that I created to use as a subform in my database. I created a select query to select the primary key from one table (tbl CA Sites) to gather records from another table (tblSite Components)
Since I have created my query I have split the database into a front end and backend application. I can no longer change the information within the select query. Before I split the database I was able to click yes/no boxes, however now it seems like the records are locked. I have created duplicate queries but they also seem to be locked. There is nothing in the query or form properties that states there are record locks. Can anyone tell me how to fix this problem and use my query in an unlocked subform.
