How can I pass a field value from one field to another... 1

[Herriot]

...using a command button?

I am creating a training database which needs to incorporate the names and addresses of Providers and their venues. Provider Addresses and Venue addresses may be the same or may be different and each Provider can have several venues.

My Provider mainform has the name and address and contact details of the providers and the Venue subform has the same kind of fields. I have a providers table and a venues table linked via the appropriate ID's

If the provider only has the one venue and the venues address is the same I would like the user to press a button on the main provider form and the address fields/contact fields of the Venues subform be populated with the info from the corresponding fields in the providers.

Provider Fields: eProvider_Address Venue_Town etc etc
Venue fields: Venue_Address, Venue_Town etc etc

I would be grateful for any guidance here.

TIA

Peter

 

[PHV]

A starting point:

With Forms![Provider mainform]
  ![Venue subform controlname].Form![Address control] = ![Address control]
  ![Venue subform controlname].Form![Town control] = ![Town control]
...
End With

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Herriot]

Thank you. That's excellent. I appreciate all your help and guidance - keep it up