I'm still a bit of a novice at Access and VBA, so this may seem trivial, but this is what I'm trying to achieve:
Table - call it Table1 - which includes a field called Field1
A form that contains the following:
- A subform of Table1 - call it subTable1 - in datasheet format
- A textbox - call it Textbox1 - that displays value of Field1 of record selected in subTable1
Easy enough.
BUT I want Textbox1 to be editable and, when edited, to update also in Table1. What would be an uncomplicated way to achieve this?