How to jump from one record to another on a form with fixed field value?

[AA Arens]

I have a form with a combo account manager (choose the name)

I have record navigation buttons on that form, along with other
fields.

I do not use queries, only tables. One of the tables is the table
account manager names and a table with the data from the form.

How to add a button that jumps to the next record (and previous) with
the same name as account manager as the record where I start to
navigate?

This means also that when I choose another acc man. it will jump to
another record with that value.

I am quite well know in Access and VB, but its hard for me to find the
right code.

Thank you and happy eastern.

Bart
Access 2003

[AA Arens]

I made the following code, but that results in an error. In ComboAM
the names of the AM can be choosen.

Private Sub NextAM_Click()
On Error GoTo Err_NextAM_Click
DoCmd.GoToRecord , acActiveDataObject, "ComboAM", acNext, 1
' DoCmd.GoToRecord , , acGoTo, 1
Exit_NextAM_Click:
Exit Sub

Err_NextAM_Click:
MsgBox Err.Description
Resume Exit_NextAM_Click

End Sub

AA Arens wrote:

I have a form with a combo account manager (choose the name)

I have record navigation buttons on that form, along with other
fields.

I do not use queries, only tables. One of the tables is the table
account manager names and a table with the data from the form.

How to add a button that jumps to the next record (and previous) with
the same name as account manager as the record where I start to
navigate?

This means also that when I choose another acc man. it will jump to
another record with that value.

I am quite well know in Access and VB, but its hard for me to find the
right code.

Thank you and happy eastern.

Bart
Access 2003

[tina]

suggest you filter the form based on the value chosen in the combo box
control, so that when you choose AM so-and-so, you only see the records for
so-and-so. record navigation then becomes a non-issue.

hth
"AA Arens" <ba***********@gmail.comwrote in message
news:11*********************@n59g2000hsh.googlegro ups.com...

I made the following code, but that results in an error. In ComboAM
the names of the AM can be choosen.

Private Sub NextAM_Click()
On Error GoTo Err_NextAM_Click
DoCmd.GoToRecord , acActiveDataObject, "ComboAM", acNext, 1
' DoCmd.GoToRecord , , acGoTo, 1
Exit_NextAM_Click:
Exit Sub

Err_NextAM_Click:
MsgBox Err.Description
Resume Exit_NextAM_Click

End Sub

AA Arens wrote:

I have a form with a combo account manager (choose the name)

I have record navigation buttons on that form, along with other
fields.

I do not use queries, only tables. One of the tables is the table
account manager names and a table with the data from the form.

How to add a button that jumps to the next record (and previous) with
the same name as account manager as the record where I start to
navigate?

This means also that when I choose another acc man. it will jump to
another record with that value.

I am quite well know in Access and VB, but its hard for me to find the
right code.

Thank you and happy eastern.

Bart
Access 2003