i need everybodies help on this one read next

[pagoto123]

i have 5 textboxes that when i enter a director of a film and press a button it shows me the details of the film in those boxes . now i want to make a button to read next record because a director may have multiple movies directed . Datagrid doesnt work for me because it not accepts images ............. please help me on this one .

[jhardman]

i have 5 textboxes that when i enter a director of a film and press a button it shows me the details of the film in those boxes . now i want to make a button to read next record because a director may have multiple movies directed . Datagrid doesnt work for me because it not accepts images ............. please help me on this one .

so is the page going to re-load when you push this "next record" button? I would first off, specify an "order by" in the query string, then after pulling up the details, objRS.movenext, get just the key of the next record and tie that into the button. Does that make sense?

Jared

[pagoto123]

jared what are you telling me ? what order by has to do with what i want ... i take all my records that director of table = director of textbox

all i want is the next result command to make it work .Does this make sense?

[jhardman]

jared what are you telling me ? what order by has to do with what i want ... i take all my records that director of table = director of textbox

Let me try to repeat. When the user clicks the "next record" button, do you want the entire page to reload, or not? This is a pivotal question. I was working from the assumption that you did want the entire page to reload. In that case you would want to make sure the database opens in the same order every time so you could be sure which record was supposed to be "next". Just pull up the data for the record you want, then check the index for the next record. So say you are reading record 15 and the next record with the same director is 27, the button could just say [HTML]<a href="samePage.asp?record=27">next record</a>[/HTML] If you don't want the entire page to reload, then you have an easier problem. Tie your film details db field into a hidden text box with your datagrid. When the user clicks the "next" button, execute some simple javascript to hide the last record, and show the next.