Hi,
I have a form whose record source is set to a specific table.

Next and Previous navigation buttons were added using the wizard.

I added a listbox whose row source is a query of the same table as
the form's record source. I created the listbox using the wizard and
checked the "Find a record on my form based on the value I select in
my list box".

What I want to do is complete the 'synchronization' of the list
box. If I click the next or previous button, I want to set the listbox
to go to the same record the form is on. I tried to follow code
examples, but unfortunately it didn't work and it wasn't easy.
My data in the table behind the form and listbox does have a 'ID'
that is a primary key. It shows for display purposes in the form (you
can't change it or set it). It's also the hidden column in the
listbox.

Does any know how to do this in this situation? Maybe there's a
tutorial.

I tried to look on MSN's site.... I abhor there help pages because
they're so confusing and don't match the scenario I have half the
time.

Again.. the challenge is to set the listbox to the same record the
form is on, when the user clicks the next or previous buttons.

Any help would be greatly appreciated!!
Thanks!!

Vmusic wrote:

You might try google groups (advance search). Here's a link for a
similar problem thread.
http://groups.google.com/group/comp....27c2a24ed141b9