Change the record source on my form

[BigMac4]

Hi can't see what went wrong but I have built a form but when I go to next record it is showing the next Id record but I want it to show the next product how can I change the record source please



Mac

[June7]

Not enough info. Should not need to change RecordSource. If you want to provide db for analysis, follow instructions at bottom of my post.

[BigMac4]

More info is I have an ID field and a product code field in my form when I click next record it shows information based on the next number in the ID field what I need is it to show me the next Product code.

Thanks
Mac

[June7]

Still don't get it. How is the form supposed to know what the 'next' product code is? If you can't or won't provide db, don't think I can help.

[BigMac4]

Anyway I don't know how I did it but it is working how I want it now weird but true.
Thanks anyway