Sub Form in Access 2019

[Olutimi]

Hello All,

I need some help please. I want to select a row/record in a subform by selecting a check box. On clicking the check box the form says it is read only.
Please advice.

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

Here are just a couple of tips for you:

1. Feel free to ask any question you like, however basic you may feel it is, or even if it has been answered before. Our expert members thrive on helping you out!

2. If you prefer a dark theme to the forums, just go to the bottom left of this forum and click "Default style". You will then see a selection of themes to choose from. I like Shades of Blue.

3. If you like any of the answers you get, feel free to click the "Like" link on the bottom right hand corner of the post. If you hover over the Like link, you can even choose the type of smiley.

Above all, hang around here, have fun, learn stuff and join in.

 

[theDBguy]

Hi. I have moved your question out of the Introduction forum.

Can you post the record source for your form? Is it a View in SQL Server?

 

[Pat Hartman]

You don't actually need a checkbox to select a record. Simply clicking in a control for ANY record selects it. Are you sure you can update the query that the form is bound to if you just open the query? If the form is bound to a table, can you update the table by opening it in DS view. If you can update the record outside of the form, then there is something in the form that is locking the record. If you can post the database with a little test data, we can take a look. There are many things that could be causing the locking.