Editable textbox to update subform

[fhickler]

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?

[pbaldy]

How would a textbox in the main form know which record to update? Without specifying, it would update the first or currently selected record. An update query could work, or code that updated the active record in the subform.

[fhickler]

...or code that updated the active record in the subform.

Maybe that's the way to go. Any ideas to point me in the right direction?

[pbaldy]

In the after update event of the textbox:

Me.SubformControlName.Field1 = Me.TextboxName

More here on referring to controls on forms/subforms:

http://theaccessweb.com/forms/frm0031.htm

[fhickler]

Me.SubformControlName.Field1 = Me.TextboxName

That sounds promising. But one problem is the field isn't editable. It's a plain text field who's control source is =[subTable1].[Form]![Field1]. I'm guessing that if it has a control source of another field then that would make it not editable. But I want it to display the current value of the field AND be editable. So maybe have it be unbound with no control source, and then fill it with a value when the main form initializes via code (basically the reverse of the code you cite)? Am I guessing correctly? What would that line of code look like?

[pbaldy]

The line of code wouldn't change, you'd just add it to the main form's load event too. Or current event.

[Gicu]

In the OnCurrent event of the subform add Me.Parent.Form.Controls("TextBoxName")=Me.Field1. Then do what Paul said in the AfterUpdate of the textbox on the main form. Leave the textbox unbound.

Cheers,
Vlad

[fhickler]

Thanks everyone. This should work great.

[pbaldy]

No problem, post back if you get stuck.