listbox to continuous subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main form that has a subform located on it. The sub is the many to
the mainform one and the subform is a continuous. The sub is where the users
select provisions associated with the mainform record. Rather then select
each item (which can vary in number) the users would like to have the abiltiy
to select the items from a listbox (on the mainform) and have the subform
populate with those selected items. The mainform and subform are bound to
their respective tables.

I am baffled on how this would be coded. So, I seek help from those of you
out there that might have done this already. Any assistance would be helpful
on this. Thanks in advance.
.... John
 
create subform records
---

Hi John,

"the users select provisions"

do you have a definition table with ProvisionID?

"have the subform populate with those selected items"

what is the table that would need to have records added to it?

here is what could happen:

loop through the items selected in the listbox
for each, create a new record using an APPEND query

when done, requery the subform and the new records show up ready to fill
out.

we can help you with the coding for this -- we need to know more about
what the relevant tables and fields are called, the data types, and
default values (if any)

to help you understand what we tell you about constructing the SQL for
an Append query in code, send me an email and request my 30-page Word
document on Access Basics (for Programming) -- it doesn't cover VBA, but
prepares you for it because it covers essentials in Access.

Be sure to put "Access Basics" in the subject line so that I see your
message...


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Crystal, thanks for the nudge in the right direction. I got it to work out
the way it needs to. Thanks.
*** john
 
that's great, John ;) happy to help

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top