Difficult one: dynamically select field to update

[mkblack]

In the screen shot, you see Text2 displays the effective date and it lets me update it. In Text8 I would like it to say Document_Date_Effective when I am editing that field.

[pbaldy]

I would expect the combo to be a field list, not a data table. Attached is a picture of the properties of my combo.

[pbaldy]

I think your code with the data table as a source is putting a value in the textbox, not changing the field it's bound to.

[mkblack]

Ok,. I am done. Somehow this did not work earlier, but is working now:
Me.text8.Value = Me.Combo0.Column(1)

Have a great weekend!

[mkblack]

Thank you for your patience, again, and sorry for the sporadic messages!!!!

[pbaldy]

If you're happy then I'm happy, but that doesn't appear to do what you initially described, or I completely misunderstood what you were trying to do.

[mkblack]

here's the complete statement:

Private Sub Combo0_AfterUpdate()
Me.Text2.ControlSource = Me.Combo0.Column(1)
Me.Text8.Value = Me.Combo0.Column(1)
End Sub

I might have not been clear earlier, but this does what I need it to do: when the form is on DOCUMENT_ID = 59, I want to allow the user to select from the combo which field they want to work on. Then, the two text fields will show:

Text8: the name of the field
Text2: the current value of the field, and would allow the user to edit it.

both these work now, so I will start with this knowledge and incorporate this type of form into the structure I am building.

[pbaldy]

If you change the value and leave that record, are your changes still there when you go back to that record?

[mkblack]

Yes, the values seem to update after I hit tab, and thhey remain. Somehow the value of the combo box doesn't remain, but for now I am happy the way it is. I'll let you know if I run into unexpected issues.