reading combo.column(1)

[fathi]

on the audit trail modul

when the field is combo box I need to capture the combo's column(1) to my audit trail table

i used the code :

If TypeOf ctl Is ComboBox Then
rst("OldValue") = ctl.OldValue.Column(1)
End If

but it's not working

can any one help me with that

many thanks in advance

 

[Dreamweaver]

The old value is only the value stored in the field assigned to the combobox the columns don't have an old value.

you could get it by looking it up but the major problem there is an autit trail can deal with loads of combos all with different tables used for there rows plus they can also have a value list or list of say forms, reports.


To Get the old value use ctl.OldValue

Mick