Hi,
I am having an odd problem with my update pages.

On my site I have a stockist locator that lists all the brands the shop sells and a search facility so that if you only want to find shops that sell a certain brand you can.

I updated one shop in Cumbria's details to show that they stock LAG acoustic guitars which worked fine. When I go to the stockist locator for LAG guitars the shop doesn't show in the browse section, but Cumbria does appear in the county search drop down menu ( you can see this at www.bandm.co.uk/StockistLocator/Browse/BrowseLAGAcoustic.asp )
When I click on Cumbria to see all shops in Cumbria that sell LAG acoustics I get this error:

Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/bandm2006/StockistLocator/CountySearch/LAGCounty.asp, line 557

This is odd because I know the shop details exist otherwise cumbria wouldn't appear in the County menu. Also if I go back to my amend page in the Admin area everything is set as it should be. The tick box adds a Y to the database field and the stockist page are set to show all with 'Y'.

I downloaded my database and tested it in Dreamweaver. The recordset can see the shop and all tests work yet when I preview it locally I get the same error. I don't understand it as I know the error I'm getting means the record is no longer there but I know it is adn dreamweaver can see it. Is there something obvious I'm missing. this is only happening on the this one record.

Thanks
Kirsty

Kirsty