Adding Multiple Records from a form

[Tolu]

Hello
I am kind of new to VB. I am trying to add multiple records to a
table from a form. I have a couple of checkboxes and I only want to
add records of checkboxes that has values inside them. I have seen a
couple of answers about using recordset and SQL but I don't have a
strong foundation in them. I can understand the codes if I see it as
in if I see statements in SQL or in VB. Please I would appreciate it
if anyone can show me a few lines and point me in the right direction.
As in I know if one is using SQL, one would use the insert command.
Anyways Thanks for everything, I would appreciate any form of help.

 

[Niklas Östergren]

Hi Tolu!

To start with, what recordsource are you using for your form, is it an
unbound form, table record source or query?

If you are using a unbound form then you for sure need to use recordset or a
query to apend a record in tables. But if your form allready have a table or
a updatabel query as a recordsourse then will everything that is written on
the form be added, as long as the property AllowAdditions is set to TRUE.

Please give me a little more info about our form and I´ll try to help you
out.

It´s quit late here so I´ll go to bed rigt now but I´ll look in to this
forum early tomorrow morning.

// Niklas