Multiple Records from 1 Form

[chris]

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

 

[Larry Linson]

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>

Alternatively, you could (although I favor using bound forms for almost all
purposes in Access) use an unbound form, and create Append Queries for each
checked letter, then clear the check boxes. Yes, I suspect you did "simplify
a bit", as this approach doesn't make a lot of sense to me.

Larry Linson
Microsoft Office Access MVP

 

[Christoph]

 > 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>

Alternatively, you could (although I favor using bound forms for almost all
purposes in Access) use an unbound form, and create Append Queries for each
checked letter, then clear the check boxes. Yes, I suspect you did "simplify
a bit", as this approach doesn't make a lot of sense to me.

 Larry Linson
 Microsoft Office Access MVP

This is new stuff to me but I will try it out. Thanks so much for the
comments.

Christoph