updating text fields with option buttons

[redtechcoms]

Hi

I new to VBA and having a few problems with a database I'm working on.

I have a form that contains customer details. The are two sections one
for the Registered Office Address and one for the Trading Office
Address. I want to be able to place 2 option buttons (yes/no) on the
form that will allow the user to auto fill the Trading Office Address
fields if the Trading Office is the same as the Registered Office.

Any suggestions on the best code to use would be greatly appreciated.

Kind regards

David

 

[rhiannon]

kool

 

[Duane Hookom]

I would use a command button with code like;

Me.txtTOAStreet = Me.txtROAStreet
Me.txtTOACity = Me.txtROACity
'...other similar code

 

[redtechcoms]

Thanks Duane

If you are able to provide a little more detail on how the code should
look this would be much appreciated.

Regards

David

 

[Duane Hookom]

If you are able to provide more details on your control names on your form?

 

[redtechcoms]

Hi Duane

Thanks for your help I got the other bits I needed to make it work.

Kind regards

David