Audit Log

[Superglide]

I have built an audit logging capability into an existing system; basically any time data changes on a form the audit log captures previous values and writes them to an audit log table. I accomplish this using VBA and various form properties (e.g. OnDirty).

The combo boxes on my form execute queries and grab multiple columns of data from the table field; I do this for ease of use for the user. For example, instead of display a list of record ID's, I display a list of names. The record ID is the bound column, but it's the names that display.

When the combo data selection changes (i.e. the user selects a different name from the list) then the audit log writes the previously selected name to the log. However, what is written to the log is the previously selected record ID, not the previous name.

Is there a way, in my VBA, to capture the second column of data from the combo box so that I can write that instead (or also)?

 

[SpentGeezer]

<comboboxname>.column(1)..See attachment for quick demo:

 

[Superglide]

Sweet. That was exactly what I needed.

Now that I see it, I see that it was obvious. Just learning...

Thank you much, SpentGeezer!