Problem with DROP DOWN list

[Newsgroup_User]

I created simple Vendor Form.
The form is based on MS-ACCESS2002 .mdb table Vendors). There is a field
called: Category
I created a Recordset for CATEGORIES table (which tests fine).
On the form I placed a drop down (List - object), and then I defined dynamic
asignments, so the CATEGORY_ID (from CATEGORIES table) should prime
CATEGORY_ID in the VENDOR table. For some reason when I test the page I get
an arror:

ADODB.Field error "800a0bcd" Either BOD or EOF is True, or the current
record has ben deleted..........

This is a simple ADD RECORD type form, I don't understand why this is
happening ?
Does anybody have a clue ?
Thanks

Arthur

[Newsgroup_User]

Probably because there are no records in your recordset.


"Artuhr K" <nospamoptron@sbcglobal.net> wrote in message
news:e26lsa$akg$1@forums.macromedia.com...
>I created simple Vendor Form.
> The form is based on MS-ACCESS2002 .mdb table Vendors). There is a field
> called: Category
> I created a Recordset for CATEGORIES table (which tests fine).
> On the form I placed a drop down (List - object), and then I defined
> dynamic asignments, so the CATEGORY_ID (from CATEGORIES table) should
> prime CATEGORY_ID in the VENDOR table. For some reason when I test the
> page I get an arror:
>
> ADODB.Field error "800a0bcd" Either BOD or EOF is True, or the current
> record has ben deleted..........
>
> This is a simple ADD RECORD type form, I don't understand why this is
> happening ?
> Does anybody have a clue ?
> Thanks
>
> Arthur
>
>
>