DAO and enum`s

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. ?

VB Code:

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

is it me or is that banner getting bigger ^^


Seahag

Does rstVelocity.Seek "=", CStr(dec.m_MediaType) work?

Don't think so.

Isn't it so the enumerator represents a number , you can use the referencing name in code but you're working with the number.

I think it would be better to work with a UDT and fill them needed values accordingly.

your right no worky.


UDT.. prolly will work.. to much to change now..
i will remember that for my next project.

Enums are great for pickin up spekking mistakes. :D