me.textbox1 = mainform.textbox1

[baccess]

Hi Experts,

I have 3 forms
1st is main form which has only 2 fields <Period> <Region>

2nd and 3rd forms has so many fields but 2 are common in each period and region\

I don't want to enter again and again period and region
once I enter in main form it will have to copy into table2/form2 and table3/form3

how to I do that?
Please help

 

[dhookom]

Why not simply set the link master/child properties of your subform controls? This will automatically enter the values from the main form into fields in your subform.

Duane
Hook'D on Access
MS Access MVP

 

[baccess]

Hi Dhookom

I am new in Access, would you explain me how to I make a link of master/child.
please send me the test database if possible
I highly appreciated your reply


Thanks & regards

 

[dhookom]

baccess,
Consider opening a sample database such as Northwind. You will almost always find a form with a subform. Also, check Help. If you are still having trouble, post back.

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

These Tech on the Net links are very good with a lot of images.

http://www.techonthenet.com/access/subforms/index.php

http://www.techonthenet.com/access/subforms/link.php