Navigating Main Form Only

[jedsall]

I have a main form and a sub form. I have disabled the stock navigation buttons and use only wizard created navigation buttons.

My issue is when I click the navigation buttons I scroll through each sub form entry before advancing to the next main form record.

How can I have the navigation buttons cycle through only the main form records?

 

[RuralGuy]

What version of Access are you using. Which form has the Nav Buttons and what is the code behind the buttons?

 

[Mike375]

I think I got the attached from LPurvis.

This is a simple one =[CurrentRecord] & " of " & Count(*) but need to add the arrows

Or ="Record " & [CurrentRecord] & " Of " & RecordsetClone.RecordCount & " Records"

 

[RuralGuy]

Leigh knows his stuff. Do you have an example of the problem you described in your first post that we could look at?

 

[jedsall]

I'm using Access 2003. I looked at the above examply and that's not quite what I'm looking for.

Imagine that example DB containing a subform that lists transactions pertaining to each contact. When you try to navigate from contact to contact I have to click the arrow once for each record in the subform before the contact form progresses to the next contact.

 

[RuralGuy]

When you turn on the NavButtons for the MainForm do they work the way you want? Which form currently has the Nav Buttons and what is the code behind the buttons?