As I said, I got it to work with one "option"...I now have a Frame option and a Set option. The Frame option worked before but now, because there are two "option" pull-downs, it fails and I get this error:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/dealerdetail_2.asp, line 231
which is this line:
ATC_itemSetDescription = "" & cStr((rsSetsLookup.Fields.Item("OptionName").Value)) & ""' column binding
I know this second pull-down (Set) doesn't have anything associated with this particular product so I need it to quietly sit in the background and appear only if the particular product needs a "Set" option.
In this "rsSetsLookup" recordset, it requests a "ID" parameter: Request.Form("cartname_eCart_1_ID_Add") in the "paramItem" and the "paramOption" pulls from the sent form.
Because the eCart_1_ID_Add is not empty (it's being populated by another "option" pull-down), the rsSetsLookup recordset tries to fill the ATC_itemSetDescription even though it's empty. If an Option was available from the form, this would probably work. Unfortunately, not all of my products will all have both/all options available at the same time.
Does this make sense and can you help? Thanks