Go to next (UNIQUE) record

[Westside1st]

Hello experts

I'm having an issue solving this puzzle

I have a query which include linked tables
(please check the uploaded Image)

In the form I had a command button that had a VBA code On Click

DoCmd.GoToRecord , , acNext

My issue is that the REQ_NO field contain a duplicate records because of the linked table ... So when I go to next record by clicking the command button it shows me the same record details multiple time

for example :

I'm in record no. 12 when I click next it moves to 13 when I click next again it moves to 14 ... but when I'm in record 29 and I click next it moves to 29 and when I click next again it moves to 29 and I click next for the forth time then it moves to 30 .
And that because 29 is a three records in the query.

So is there a way to tell the access to move from 29 to 30 and from 30 to 31 without going through all the duplicated record ???

Thank you all

 

[welshgasman]

You do not say why you want to do that?
If you only want one record for each reqno, then I believe you just group on that field, and it might be random, what the other data holds, but that would get you what you want?