gotorecord until next unique record is found

[cdasteve]

I have a form/subform based on a query. The query has clientname and
medname. (This info comes from a flat file bill that we have to
process monthly, so we're not bothering to make it relational.) The
form shows client name and the subform shows the multiple medications
the client is on in datasheet view. A combobox (based on another query
with no duplicates) in the main form allows me to find and select the
next client but I want to create a navigation button to take me to the
next client in just one click. The built in navigation buttons
obviously don't achieve this since each client has multiple med's.

I've searched the groups extensively. Any help is greatly appreciated.
Thanks.

 

[TC]

The navigation buttons >on the main form< should take you from client to
client. These should appear directly beneath the navigation buttons for the
subform, if you have set the relevant main form property to get those
buttons.

HTH,
TC