Copy Information from Form to subform with button

[Shadez]

I am sure this has been discussed . I can't seem to find it anywhere though. I am still quite the novice in the coding off access so please be specific.

For the example purposes lets make this as simple as possible: Lets say I have a foem called Main and a subform called subform

I want to copy 2 fields company and name to the subform. Could someone post an example of the best way to accomplish this?

 

[LonnieJohnson]

Let's call the fields on the Main Form and the sub form both
Field1 and Field2.

I will assume that you only have one SubForm record for each MainForm record. In the click event of your button you cab put...

Me![MySubFormName].Form![Field1] = Me!Field1
Me![MySubFormName].Form![Field2] = Me!Field2
ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[Shadez]

thanks a ton. Thanks for assuming the piece of info I forgot to give. Yes one record to one record. Using it as a way for people to selectively update information from a larger Database.