create many subforms

[liborp]

Hi there,
I'm litte bit a greenhorn of Access forms.
I have 7 tables one of them "Movie" is the main. The remain ones are for details (Subtitle, MovieTrailer,ScreenShot...). These remain tables have relationships many-to-one to the Movie.
I try to create main form of movie with six subforms. When I put only one subform to the main (simply used Form wizard) everithing works fine. But for more subforms while I'm trying put new record error occured "The Microsoft Access database engine cannot find a record in the table Movie; with key matching field(s) idMovie".

I've set proper relationship in DB designer.
I really don't understand what is wrong. Why it wokrs for one subform but for many it doesn't.
Shall I use query to fill subforms?
Can anybody help?
Thank you

 

[DCrake]

Simple Software Solutions

Why do you want to have many subforms on your main form when your sub form can be built using a query of all the child tables?

 

[liborp]

Thanks for response!
Because I want to have all data on one page (form). Well as I mentioned I'm pretty new in access forms. But when I put subform on main page and then I check Data source of subform, there is some select query anyway. So what is difference?
So shall I use subforms, don't I?
What is your suggestion?

 

[MStef]

Make a Mainform with 6 TAB CONTROL.
In Tab controls put 6 subform.
Look at "DemoTabSubA2000.mdb"