 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Multiple Records from 1 Form
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 > Hi, it seems so simple but I just haven't been able to do the > following (I simplified the situation here a bit): [quoted text clipped - 42 lines] > > Christoph On May 1, 1:46 am, magicdds- <magic...@discussions.microsoft.com> wrote: > You might try this: > [quoted text clipped - 62 lines] > > - Show quoted text - Mark, this is exactly what I needed! Thank you so very much! Christoph |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.