Multiple Records from 1 Form

[schulze404]

Hi, it seems so simple but I just haven't been able to do the
following (I simplified the situation here a bit):

I have a very basic form that looks like this:


[ ] Alpha
[ ] Beta
[ ] Gamma


<SUBMIT>


In words: there are three checkboxes and a button at the end of the
form.


In addition, I have a basic table with only one text field "Letter"
defined.


When the button is pressed, I would like for as many records added to
the table as there are checkmarks. In other words, when only the
Alpha
checkbox is checked, I would like to add the following to my table:


Letter
--------------
Alpha


If Alpha and Beta are checked, I would like the following records
added to the table


Letter
--------------
Alpha
Beta


In other words, adding two records, etc. If all three are checked,
then three records are added.


I'm fine with VBA or whatever needs to be done but this has been
driving me crazy for a while now.


If this is the wrong group for this, I apologize. Maybe somebody can
point me into the right direction.


Any help is greatly appreciated.


Christoph

 

[Duane Hookom]

Have you considered using a multi select list box for selecting "letters"?
Or, how about a temporary table with the letter and a yes/no field. With the
small table, you could simply use it in an append query to append the letters
where the yes/no field is true.

 

[Christoph]

Have you considered using a multi select list box for selecting "letters"?
Or, how about a temporary table with the letter and a yes/no field. With the
small table, you could simply use it in an append query to append the letters
where the yes/no field is true.

--
Duane Hookom
Microsoft Access MVP

Hi, it seems so simple but I just haven't been able to do the
following (I simplified the situation here a bit):

I have a very basic form that looks like this:

[  ] Alpha
[  ] Beta
[  ] Gamma

<SUBMIT>

In words: there are three checkboxes and a button at the end of the
form.

In addition, I have a basic table with only one text field "Letter"
defined.

When the button is pressed, I would like for as many records added to
the table as there are checkmarks. In other words, when only the
Alpha
checkbox is checked, I would like to add the following to my table:

If Alpha and Beta are checked, I would like the following records
added to the table

In other words, adding two records, etc. If all three are checked,
then three records are added.

I'm fine with VBA or whatever needs to be done but this has been
driving me crazy for a while now.

If this is the wrong group for this, I apologize. Maybe somebody can
point me into the right direction.

Any help is greatly appreciated.

Christoph- Hide quoted text -

- Show quoted text -

Thanks, Duane! I'm experimenting with the temp table... !

Christoph