Textbox updated by other control AND bound?

[Montez659]

It's been a while since I've been here, but alas, we all always return to our programming ways.

Can't seem to find what seems to be a simple thing - probably just can't figure out exactly what to search for.

I want a textbox updated from a combobox - easy enough:

=[cmbContact].[Column](0))

But I also want it bound to the CT_ID field on the form. Essentially, the user chooses a contact from the combobox, and the Contact ID field gets updated on the form and saved into the db.

Simple enough, or so I think. Thanks in advance!

 

[Montez659]

Well, not sure why I was making it so tough. I just added some VBA on the AfterUpdate event that looked like this:

txtCT_ID = Me.cmbContact.Column(0)
Me.Dirty = False