Syntax question Combo.OldValue

[millrat]

Hi all,

I have audit trail using Me.CombldValue and Me.Combo.Value. This gives only numbers in my table i.e. Column(0).

How to use Column(1) for text and what is correct syntax for below?

e.g. Me.Combo.Column(1).OldValue...(this don't work but it's what I want)

Cheers,
millrat

 

[PHV]

Perhaps you may retrieve the old text value with DLookUp ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[millrat]

PHV,

Thanks for the quick reply.

I'm not familiar with DLookup but...

DLookup(Me.Combo.Column(1),, Criteria? Not sure what to put here)


Cheers,

 

[PHV]

What is the actual SQL code of the combo's RowSource property ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[millrat]

PHV,

Only 2 columns...

SELECT tblArea.ID, tblArea.Area FROM tblArea

 

[millrat]

PHV,

Is this on the right track?

DLookup(Me.Area.Column(1),, "tblArea.ID =" & Me.Area.OldValue)

 

[PHV]

strOldText = DLookUp("Area", "tblArea", "ID=" & Me!CombldValue)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[millrat]

PHV,

Thanks, works like a charm...

Cheers,
millrat