Please please help!!!

[kaylee]

I am in need of some help. I am only familiar with the basics of access, and I normally look up any problems I come across online but this one has me stumped. I have created a form with client details, and subforms with memberships, personal training packages, class registration, etc. The problem is, when I click through the clients, I have to press the next button once per record in the subforms before it advances to the next person. I want to be able to click to the next person without having to go through each individual record. I have attached a photo. PLEASE help me!

[Perceptus]

Does Ctrl + PageDown go to the next record?

[vicsaccess]

Kaylee, two things come to mind that i have done and had to learn the hard way. what is the link between form and subform, client id or id. second not sure how you are setting up your next button, macro or vba, it sounds like it is set to advance per subform record rather than client id. seems like alot of what we learn is unfortunatly from fixing our errors

[kaylee]

The link is Client ID. My next button I am entering via the quick insert buttons on the ribbon. I have been looking for another way to set up the button but I am only able to find the wizard that I have been using. I'm so frustrated :S

[kaylee]

Does Ctrl + PageDown go to the next record?

Yes, but I am looking to advance to the next record from Client Profile, not Memberships.

[kaylee]

The link is Client ID. My next button I am entering via the quick insert buttons on the ribbon. I have been looking for another way to set up the button but I am only able to find the wizard that I have been using. I'm so frustrated :S

[Perceptus]

if you goto the subform and add a helper sub.

Public Sub Helper(Keycode As Integer, shift As Integer) 
  If Keycode = KeyCodeConstants.vbKeyPageDown And shift = 1 Then
    Me.Parent.Form.MoveNext
  End If
End Sub

and then for the KeyDown Event, Pass the event to the helper.

like for the keydown event for field1

Private Sub Field1_KeyDown(Keycode As Integer, shift As Integer)
    Call Helper(Keycode, shift)
End Sub

Now you can Press Shift Pagedown in the field1. and have it force the parent record to goto the next record.

[vicsaccess]

it has been a little while since i have used a macro but i did do a little research and remembering. if, in design mode, you right click on the button it should give a menu and towards the top is "Build event" select this and open the macro tools. this is where all your control of a macro is if you hadn't been there. i'm guessing that your "Object name" is probably the name of the subform. If you desire the button to move to the next record of the form instead of the subform then change this to the form name and should fix it? hopethishelps

[kaylee]

THANK YOU all for your help. I was finally able to get it working.

[vicsaccess]

What was the problem, share please for the next person having the problem.

[kaylee]

I tried all of the above suggestions with no success. Frustrated, I decided to rebuild the form from scratch. I am embarrassed to say it was as simple as this: In my original form, I had added the next record button last. In the new form, I added it immediately after I added the parent table fields. I THEN added the subforms. After adding the subforms, the next record button is still scrolling through the parent table records as it should. So it was much simpler than I thought. Again, thanks to everyone who took the time to try to help me out of my jam!

Kaylee

[vicsaccess]

Perceptus-in post #2, what was you checking for? I've never heard of trying that.