Combo Box and Subform

[Guest]

I have a form with a combo box called "Number of Locations:" that allows me to select from 1-10 locations.

What would I need to do to have the selection open a subform to allow entries for the number of locations entered

If 1 selected see the following -
Location1 Address
Location1 City

If 2 selected see the following -
Location1 Address
Location1 City

Location2 Address
Location2 City

And so on. There are more fields for the address but I can add those later if you can help me with the basics.


Print

 

[John Vinson]

I have a form with a combo box called "Number of Locations:" that allows me to select from 1-10 locations.

What would I need to do to have the selection open a subform to allow entries for the number of locations entered?

If 1 selected see the following -
Location1 Address:
Location1 City:

If 2 selected see the following -
Location1 Address:
Location1 City:

Location2 Address:
Location2 City:

And so on. There are more fields for the address but I can add those later if you can help me with the basics.

Why not just use a continuous Subform? This will allow you to enter
any number of addresses. The Subform should be based on an Address
table related one to many to this table; you should certainly NOT have
fields named Location2 Address or Location10 City. Instead, have one
to ten *RECORDS* in the address table.