Goto Next Record in ComboBox (using code)

[rheide]

Hello everyone,
I am trying to figure out the correct way to get the following to work (it sure seems simple, but I can't figure it out)....

I have a form with 3 subforms. On the main form, there is one drop down box that list the item that is linked to all the other tables (lets just say its someones last name). When I pick the person from the dropdown menu, all the other subforms update with that person's information.

Rather than having to go click on the dropdown menu and choose the next person in line, I would like to have a button that just advances me to the next person in the list.

If the data wasn't coming from a dropdown box, I would just use the DoCmd.GoToRecord , , acNext command, but that doesn't work the way I have it set up.

Any suggestions or keywords to research on would be appreciated.

Thanks and have a great day,
Randy

 

[Jack Cowley]

Base the main form on the same table/query that the combo is based on. Create the query using the Wizard and select the third option on the first screen, "Find a record....". Set the Master link to the ID field on the form (it can be hidden) instead of the combo box.

hth,
Jack