Radio and check boxes

[bursteffect]

im working on a transportation database, and i need a few pointers . in my form i have clients that will be going to the doctor, so i have a pickup address, time, city ,zip,phone ect. going to a destination address, time,city , zip ect. which is counted as one trip. i want to create a button, or checkbox that will when checked, will add another leg to the destination just incase the client decides to want an additional trip. who knows maybe she want to go 6 places. is there a way this can be done.

[June7]

What do you mean by 'add another leg'? You want to add a record in table?

[bursteffect]

What do you mean by 'add another leg'? You want to add a record in table?

no i want to be able to enable and disable fields.

[June7]

Code can enable/disable controls on form. How will that 'add another leg'? What is data structure? Do you have similar fields in table for up to 6 'legs'?

Want to provide db for analysis? Follow instructions at bottom of my post.

[bursteffect]

when you open the database, i hope you can understand what im trying to do, im not good in explaining things, i have 3 check boxes which is for each destination, i want to be able to checkmark only the destination i want to use and disable the other ones, until i need them. if all is checked all is enabled .

[June7]

Set the Visible or Enabled property of controls to No. Then use code (macros or VBA, I use only VBA) to reverse the property setting. Code must be in some event, such as checkbox Change event. Example:

Me.SITE_DESTINATION2.Visible = True