finding next group of records
I have a series of buttons in my database, the usual, "next record", and "previous record".
What I would like to do is have a button that finds the next "group" of records. Specifically, there is a field in the records that identifies the group... ie "group1", "group1a", "group4" etc (note this is for clarity, the group names are not simply ordered numbers).
I'd like to make a button that finds the next record where the group name changes, effectivly allowing you to jump from group to group. There may be as many as 500 records in the same group, ie the search will have to root through that many records before getting to a record where the field "groupname" changes.
Thanks very much!