checkbox to autofill textboxs

  • Thread starter Scott_66701 via AccessMonster.com
  • Start date
S

Scott_66701 via AccessMonster.com

hi, i have a couple sections on a form. One being customer address,city,
state,zip and then other section with same fields but used for shipping
information. is there a way to click a checkoff telling access that the
information in the customer section is the same as the billing information?
 
P

PieterLinden via AccessMonster.com

Scott_66701 said:
hi, i have a couple sections on a form. One being customer address,city,
state,zip and then other section with same fields but used for shipping
information. is there a way to click a checkoff telling access that the
information in the customer section is the same as the billing information?

You could put code in the Check event that copies the data... Not very pretty,
but flexible.

Private Sub chkCitiesMatch_Click()
If chkCitiesMatch Then
Me.txtCity2 = Me.txtCity1
Else
Me.txtCity2 = Null
End If
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top