Handling Subform Cell Events at Runtime

[Simbiose]

Hello there,
I was asked to create user input interfaces for an Access database and now I'm stuck on how to handle subform events specifically for cells.
I have a subform named dgvRecipesList (marked with a red square) that is based on data gathered from a table named tbReceita:





The subform, at the form's load event has the property AllowEdits disabled.
What I'm trying to achieve is, the user must only be able to edit cell values from the column identified as QT.
The button below the subform, with the text Editar, will only be enabled when the user selects any cell from the column QT.
Then, when the user clicks the button with the text Editar, the subform's AllowEdits property will be enabled and the text of the button will change to Guardar (which means save).
After this, the user can change the desired cells' value and when done clicks the button that now has the text Guardar, saving the new values into the table, disabling the subform's AllowEdits property and, finally, reverting the button text to Guardar.


The problem I have at hand is that I have no way of handling events for the subforms cells, at least not directly from the designer, so how can I achieve this?

[Bob Fitz]

Why not just set the Enabled property to false and the locked property to true for all the fields except the QT one.

[Minty]

The subform itself has events, but I don't think you need them.

In the subform design view select the controls for all the fields except QT and in the data tab in properties change the property named Locked = Yes
This will allow edits only for the QT field, no need to switch them in and out.

[Simbiose]

I'm not able to see any controls within the subform on design view. There's just a blank square with the link to the data table:

So how am I suppose to do what you're suggesting?

[Minty]

That's because you have inserted a Table directly.

Create a proper subform for the table data, then you will see fields and controls appear.
A table doesn't have controls.

[Simbiose]

Yeah, I just realized that it was all about how I created the subform *sighs*...
Thanks for the help and sorry for wasting time guys.

[Minty]

No problem, Access lets you do lots of things that in the real world, more experienced developers wouldn't do.
You have stumbled across one of them.

Good luck with the rest of your project.