Hello,

Trying to create a Master Detail Page set but I am getting the following error when I get to the Detail page from the Master link:

ADODB.Field error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

Any ideas?

Thanks in advance,
Jeff

Ae you running a query on your detail page and filtering it by your id column in your db?

I add a record set in my Master page filtering by DEPT code and sorting by REQUESTNUMBER.
Then I do a Master Detail Page set using REQUESTNUMBER to link Master to Detail.

so when you set-up your go to detail page link you're passing REQUESTNUMBER as your url param.
sounds ok providing this number is unique.
If this is so, you should also have a recordset on the detail page filtered
by REQUESTNUMBER then add ya dynamic text where you want it,
If this number is not unique pass your id column as a param instead.


I will give you the gun myself if this sounds gibberish <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>....shoot at will!

The only thing i can think of that would cause the old "no record" error
would be if there was a conflict between the url parameter passed
from the go to detail link and the recordset filter on the detail page.
Even if the requestnumber was not unique you would just probably get
the wrong records info........<img src=../images/dmxzone/forum/icon_smile_question.gif border=0 align=middle>

If your master page has recordset layed out with repeat region etc
select the dynamic text you want to use to link to the detail page.
In server behaviours select "go to detail" insert detail page name,
pass url parameter( choose RecordID or whatever you called it )
make sure its got the right recordset and choose RecordID where it
says column.
Then your detail page should have a recordset that is
filtered by RecordID-----Url Parameter------ = ----------RecordID
and that should work.

Failing that, cant think what could be up???

Im in need of a nice cold lager now......<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Hope you get it sorted

AAArghhh... all of a sudden I have this major migrain!! I will checkout all suggestions mentioned. One thing I am sure about is that the record number is unique, I will go from there and report back later.
Thank you all!

Its good to know that its not just my head that "MELTS" every now and again
<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Best of luck mate, dark room and all that <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

Give that Man a Ciiiiigar!! You sir are right, I did have to create another recordset for the detail page... but why? I don't get it, I thought since the record is being passed to the detail page already, I need not filter anything out anymore.

I feel like I owe you guys drinks when I am finally done with this project... thanks once again. Notice I said "when I am finally done"? I dont want y'all to get all boozed up and suddenly get wrong answers to all my questions. <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

basically, your detail page does not know what its getting.
Your telling it REQUESTNUMBER = 787878 and it thinks
yeah right, but where from?????
so ya gotta tell it
ie give it a recordset and filter it by REQUESTNUMBER=787878

<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Glad to be of assistance......mines a carling <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>