Navigation Bar Record Count not updating

[RuralGuy]

Your two comboBoxes are not moving off of the 1st record of the MainForm so the NavBar is accurately showing you the correct record. I'm sorry but I guess I just don't understand the issue yet. Also as I said, the AfterUpdate event of the 1st cbo is Requerying the Recordsource of the MainForm which will take it back to the 1st record should it have moved.

[ylatodd]

I took the requery off and still same issue. Can you try selecting a value from cboTAMCN and see if the record number changes? Then click on next and see what happens.

[ylatodd]

The problem is that If you select a value in cboTAMCN and click on next it wont necessarily go to the next value that follows, it will go to the next record after the one it shows a count for on the nav bar.

[RuralGuy]

Your Next button is simply moving to the next record in the MainForm. It is doing just what it is designed to do.

[ylatodd]

Look at the values in cboTAMCN and you will see the Next button is not going to the next value if you select a value from cboTAMCN first. If you load the form, click on cboTAMCN and select the third record available on the list, then hit next it will go to the secondvalue, not the 4th value. You will also notice if you load the form, click on cboTAMCN and select the 3rd value, the button previous will not be visible until you click on next button. Even if you select the last value. I can give you my phone number to better explain, is this a possibility?

[RuralGuy]

Both of your ComboBoxes are *not* moving the RecordPointer of the MainForm. Both cbo's are unbound and being filled in the Current Event of the MainForm. Do you use any of the IM's?

[RuralGuy]

I have Yahoo Messenger running right now and I am RuralGuy9999

[ylatodd]

Sorry for the late response. I will be on for the rest of the night, let me know if you get some time.

[RuralGuy]

Post here when you want me to load my IM.

[ylatodd]

Ready when you are.

[ylatodd]

I should be on tomorrow morning after 715 am Pac Time

[RuralGuy]

Talk about ships passing in the night.

[ylatodd]

RuralGuy Thank you for the help. Here is what your After Update macro for the last combo box is in vba:

DoCmd.SearchForRecord , "", acFirst, "[FieldName] = " & "'" & Screen.ActiveControl & "'"

Thanks again for your help.