Multiple Records from 1 Form

  • Thread starter Thread starter Christoph
  • Start date Start date
C

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>


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
 
You might try this:

On the: On click event procedure of SUBMIT command Button

If Alpha = -1 then DoCmd.OpenQuery "Alpha Query"
If Beta = -1 then DoCmd.OpenQuery "Beta Query"
If Gamma = -1 then DoCmd.OpenQuery "Gamma Query"

The Alpha Query is an Append Query that adds a record to your table with the
word "alpha" in the LETTER field.
The Beta Query is an Append Query that adds a record to your table with the
word "beta" in the LETTER field.
The Gamma Query is an Append Query that adds a record to your table with the
word "Gamma" in the LETTER field.

Hope this works for you.
Mark David
 
You might try this:

On the: On click event procedure of SUBMIT command Button

If Alpha = -1 then DoCmd.OpenQuery "Alpha Query"
If Beta = -1 then DoCmd.OpenQuery "Beta Query"
If Gamma = -1 then DoCmd.OpenQuery "Gamma Query"

The Alpha Query is an Append Query that adds a record to your table with the
word "alpha" in the LETTER field.
The Beta Query is an Append Query that adds a record to your table with the
word "beta" in the LETTER field.
The Gamma Query is an Append Query that adds a record to your table with the
word "Gamma" in the LETTER field.

Hope this works for you.
Mark David



Christoph said:
Hi, it seems so simple but I just haven't been able to do the
following (I simplified the situation here a bit):
Click to expand...
I have a very basic form that looks like this:
Click to expand...
[  ] Alpha
[  ] Beta
[  ] Gamma
<SUBMIT>
Click to expand...

In words: there are three checkboxes and a button at the end of the
form.
Click to expand...
In addition, I have a basic table with only one text field "Letter"
defined.
Click to expand...
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.
Click to expand...
I'm fine with VBA or whatever needs to be done but this has been
driving me crazy for a while now.
Click to expand...
If this is the wrong group for this, I apologize. Maybe somebody can
point me into the right direction.
Click to expand...
Any help is greatly appreciated.
Click to expand...
Christoph- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Mark,

this is exactly what I needed! Thank you so very much!
Christoph
 
Back
Top