Confused: Main Form, Subforms and New Records

[london_girl]

Hi All,

I’m hoping someone can help a very confused newbie

While I have knowledge in using MSAccess I can honestly say I am well and truly stuck. I have searched the forum, but cannot find anything to help me out … if there is anything I am sorry for re-posting. While there may be helpful responses, they mostly involve code, which I do not know.

I have a Main Form (frmPreApprovedTravel) and numerous Subforms (sfrmFlightRail, sfrmHotel, etc). I have designed my Main Form with tabs and each tab contains staff details, flight, hotel, taxi, etc information.

My problem is that when I go to the next record in my Main Form I want the Subforms (all of them) to go to the next record as well. I know this is possible but having tried to figure it out myself for the last 2 hours, but know I’m still missing something!

I would appreciate any help and thank you in advance for the help and taking the time to read my problem.

 

[CEH]

It sounds like your subforms are not linked to your main form......
Can you post the DB?

 

[Sergeant]

This will happen automatically if you have your subform controls set up with the proper Master/Child field relationships to the main form.

If you haven't done this, right click on a subform control and select the data tab...you will see the Master field and Child field.

 

[london_girl]

Guys, your both brilliant!!!!

Can't believe I made this error ... it was my Master/Child field relationships, I put the info (believe it or not) in backwards!

Thanks