DAO and enum`s

[SeaHag]

I have a problem using enums in a DAO query
seems that dec.m_MediaType = 1 when i am looking to match a STRING in a table.

Is there a way around this? or am i stuck putting index numbers in my access table. ?

rstVelocity.Index = "PrimaryKey"
    rstVelocity.Seek "=", dec.m_MediaType ' NEED STRING NOTNUMBER
        mDucting.Description.m_roomVelocity = rstVelocity(1) 'just in case we need it
        mDucting.Description.m_cfm = rstVelocity(1) * (dec.m_roomWidth * dec.m_roomHeight)
rstVelocity.Close
 
 
 
 
 
' HERES MU ENUM 
 
Public Enum MediaType
    AlumOxide
    Sand
    StarBlast
    SteelGrit
End Enum

Thanks Seahag