One Form for Multiple Entries

[gall3on]

I need some form help since I'm very new at creating forms in Access. I want to design a form that will allow me to create multiple records from one entry for efficiency's sake. For example, I want to create a new "Store" record for several cities.

How can I design a form that will likely use the following fields:

Store Name: [Generic Name to be appended with selected City Name]
Select City: [I have a table list of cities somewhere which I want to show up as a checkbox list]

Example Form Entry:
Store Name: Seasonal Store
Select City: Chicago, New York, Los Angeles

Since this is more like a 'temporary' form which will append to a master table based on values (and i'm guessing a loop sub), I don't have a true form table as a source.

 

[henniec]

I think you are approaching the table or form from the wrong direction.Wat you need to do is create two different tables - one for the store and one for the city. For each store and city you need a Primary ID number. In other words two fiels for each table eg IDStore, StoreName and IDCity, CityName. Keep the names as one word using a capital letter to make reading easier.

Populate the fields directly in the table. Create a third table that include the foreign ID number of the two tables you created, eg IDABC, IDStoreName, IDCityName plus the other fields required.

Create your main form but for the two fields StoreName and CityName you need a combobox for each one. When you select a store from your list or city it will fill the field with a number and not the store or city name.

With a query you can combine the three tables into one for reporting. The above method limits the number of records required for you store and city but increase the combinations.

Hope it helps.

Hennie