Form control not getting correct value 1

[vba317]

I have a form control called cboImpMoData
I am trying to get a value from this control with no luck. What happens is the value of the control is based on a query. The table the query is based on has three fields ID, MonDesc and finalpost. In my example code liFileMonth = the ID field not the MonDesc which is what I need. I would appreciate any help in this matter.

If Not IsNull(Me.cboImpMonData.Value) Then
    ' SET PATH OF FILE FOR IMPORT
    liFileMonth = Me.cboImpMonData.Value
    strFileMonth = GetMonthString(liFileMonth)
    ' Get Closed Option and Set File
    strFileCS = "\\salmfilesvr1\public\Client Services\Automate\Dnlds\" & (strUCI) & "\" & (strUCI) & "_CS_Data_" & (strFileMonth) & ".txt"
    strFileAR = "\\salmfilesvr1\public\Client Services\Automate\Dnlds\" & (strUCI) & "\" & (strUCI) & "_AR_Data_" & (strFileMonth) & ".txt"
    strFileFullAR = "\\Server\E\Balout\" & (strUCI) & "_AR_Data_" & (strFileMonth) & ".txt"

 

[SkipVought]

hi,

Is this MS Access? forum705

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

I'd use this:
Me!cboImpMonData.Column(1)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[vba317]

Yes this is access 2002