Adding Multiple Records from a form

  • Thread starter Thread starter Tolu
  • Start date Start date
T

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.
 
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
 
Back
Top