Microsoft Access Form with a SubForm Tutorial

[malcolmeter]

Hi mate,

I have a main for called ref and a subform called work, they are linked together so when i click next, the values in both form changes

I will like to create a new individual in ref and will like some field to be pre populated (like Ref ID) and when i click work it should be populated as well? how can i write the links back to the tables.

Please help

[rochester12345678910]

can you set the form so that when I change the data in a form using a look-up button that the data from current form page changes ?

[599CD]

@rochester12345678910 Sure. You'll probably need an AfterUpdate event for that. Look for my tutorial AfterUpdate event programming on my channel. Apparently I can't post a link to it here.

[Yodasstuff]

Thank you! Does the subform wizard always need to be used? I have about 17 fields that need to be part of the many subform relationship. Have created a continuous form with the various fields wrapping around. They need to be filtered or chosed via a combo box at the top of the form.

[suhasbajgur]

Thank you very much for the lecture.... makes it very easier for us to learn!

[gauravp13]

Thanks a lot. I am just starting in access and this video proved to be of great help.

[weilerpeter]

great video ! thanks for the help

[liamohockey]

excellent video! really helped me! :)

[No1momof3]

outstanding - you make it seem so clear and interesting not like some of the bland monotose videos which bore you. You solved my problem in 8 minutes.

[bresslau]

You just showed me how to solve my problem here at work, cheers!

[MrAhmadbadran]

thanks

[SLDOQ36]

Cool dude thanks, much appreciated