Have a query go to a specific sequential record

[Juicejam]

I need a form (with a nested sub-form) to display a numbered record of a query, e.g. I need the first to eight records of a dynamic query displayed. I currently use the gotorecord action of the docmd argument but am having trouble when the query doesn't have any records.

I guess I could do some sort of error trapping in the code but I am wondering if there is a way to actually get the query (in SQL) to go to the specific record when it is run. Can queries do this?

Thanks very much...

[orange]

Do the records have some sort of ID number?
There is no specific order to records in a table. You can place an order on records if you use a query and include an ORDER BY clause.

[Juicejam]

No, not sure sorting by id number would work. The query sorts by date/time order and I need to show the latest/newest 8 records in the query.

[orange]

Research the Select TOP query. Order by the Date/time field descending.

[Juicejam]

ok thanks but i am looking to isolate one record at a time. Guess I will have to stick to the gotorecord command.

[orange]

Use the select TOP x ... Order By ... as a recordset and process the records by means of a loop.

[Juicejam]

Hi Orange, thanks. Can you give me an exampe of processing the recordset by means of a loop? is this via code?

[orange]

sample here
http://www.classanytime.com/mis333k/sjloopsarrays.html

http://allenbrowne.com/ser-29.html

[Juicejam]

Okay thanks, it looks like all gibberish to a novice like me but i will give it a go...
I dont have a recordset in code, I was working with a built query in access then moving through that query using code.

I may have to come back to you for more help, if you can...