updating text fields with option buttons

  • Thread starter Thread starter redtechcoms
  • Start date Start date
R

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
 
I would use a command button with code like;

Me.txtTOAStreet = Me.txtROAStreet
Me.txtTOACity = Me.txtROACity
'...other similar code
 
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
 
Hi Duane

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

Kind regards

David
 
Back
Top