Command button code

[Tui]

I have created a form, and within this form are several subforms. I need a
command button which will take the data that is entered into a field in the
main form and update it in the corrosponding field in the subforms (to avoid
the user repeatedly having to fill this field out in the subforms).

Can anyone tell me how to to this?

Cheers

Kirsten

 

[Al Campagna]

Tui,
You don't have to... since the main form is related to each of the
subform tables (Parent/Child), any value on the One side of the relationship
can always be reassociated "on the fly" to the Many side in any subsequent
query, form, or report.

For example...
On the Main we have Bob Smith and his Address data (ex. CustID = 36)
In a subform we have multiple phone numbers for Bob Smith. (all have
CustID = 36)
You wouldn't add the address fields to each of the the subform
records, you would simply use the realtionship to display Bob's phone
numbers with Bob's Address information... in any subsequent query, or form
or report.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."