ComboBox Problem

[ddrew]

I have a combobox (cbo_Breed) that Holds the Breed_ID, Breed and BreedType_ID.

On the form opening I want to look at the thrird column and if its a "1" then to do something. How do I get the form to look at the third column? This is what I have written (I know its wrong, but needed a starting point)

If Me.Breed.[Column](3) = "1" Then

 

[pbaldy]

The column property is zero based, so the third column is 2.

 

[ddrew]

The column property is zero based, so the third column is 2.

Thank you but its still not right as it throws an error (Compile Error: Method or data member not found) on Column

 

[pbaldy]

Looks like you need to use the name of the combo, not the field.

 

[ddrew]

Looks like you need to use the name of the combo, not the field.

DOH! Thanks

 

[pbaldy]

No problemo!