VBA Coding for Selected features

[AdamOller]

I've developed the following form and it has all of the possible field attributes that could be selected to identify one single unique attribute. I want to be able to select all three and choose "calculate" to provide a message box that will give the unique attribute. My coding abilities are limited to the Getting to Know ArcObjects book which has helped me greatly in creating this form and adding all of the items in the drop down menus.

Thanks!

aoller1
SIUC Graduate Assistant

[AdamOller]

It would probably would not hurt to elaborate on my need(s). When looking at the attached pdf, I want to be able to select 2000 (year), 1 (route #), and house sparrow (species) and then click calculate to pop up a message box that will tell me the number of species found for that route and time year. Each selection no matter the combination will have one single unique attribute. All of this information is found in the same shapefile/attribute table. I was thinking maybe some sort of TableLookUp but reading about it on Developer Help led me to believing that was not the right choice.

[JeffreyHamblin]

Hi Adam,

My question is: if you want "the number of species found for that route and time year" -- why would you have the user select a species? Wouldn't you just have them select a route and year, and then count the number of species?

Or do you actually want to calculate the count of individuals of a particular species? Is there a fourth field for that in the table?

-Jeff

[AdamOller]

Hi Adam,

My question is: if you want "the number of species found for that route and time year" -- why would you have the user select a species? Wouldn't you just have them select a route and year, and then count the number of species?

Or do you actually want to calculate the count of individuals of a particular species? Is there a fourth field for that in the table?

-Jeff

Yes, there are four different species and there is a fourth field that has total number of species that has a particular year, route, and species ID associated with it in the row itself.

[JeffreyHamblin]

Yes, there are four different species and there is a fourth field that has total number of species that has a particular year, route, and species ID associated with it in the row itself.

Oh, I see, you're not actually calculating the value -- you just need to return it from a single field.

One way to do that would be to use either an IFeatureClass.Search or an IFeatureLayer.Search, and pass in an IQueryFilter with its WhereClause set to the fields and values for your three parameters. From the cursor returned from that, get the value of your fourth field.

Here's the WhereClause reference to get you started.

-Jeff