Access VBA - method for detecting a change of current record

[ctaylor]

I want to find a method name for changing records.

When I use navigation buttons to flip between records this creates an event. I want the VBA form module to "detect" this event and autocomplete the value of the unbound text box "txtDescription" based upon the value within the bound combo box "txtPartNumber" which is bound to a field in the underlying table.

It is trivial to do this with a query, but I want to learn to do this programatically. I can get this to work with OnLoad, and OnClick methods, but the value within the unbound field is not updated when records are changed.

There has got to be a method for this.........

 

[Robert Dunstan]

Have you tried using the OnCurrent event?

 

[ctaylor]

Thanks! This is just the information I needed!

It works great now.