Horse Race Description

[Bez]

I have an Access database that is using the COM interface very successfully but I am having trouble picking up the description of a horse race.

I would expect the eventname field of a bfEvent to contain stuff like 5f mdn stks like you see in the BA interface but it only ever has bath or hayd etc.

Here is my code:

Dim Events
Dim Evnt

Events = ba.getEvents(SportID)
For Each Evnt In Events
Log "Event Name " & Evnt.EventName
Next

Interestingly if I DIM Evnt as bfEvent the For Each line gives me an Object Required error.

Does anyone know how I should be picking up the race description, please?

[Tradyann]

With "Horse racing - today's card" no ?

Try with "Horse racing".

[Bez]

Thanks for the clue Tradyann )
The resulting code seems a bit over the top but I now have it working.
Thanks very much for helping