I need a form to add a new record to a table.

[Alan of St Breward]

I have tried many ways to connect a form to feed a table but nothing seems to
work, the otherway round (tables feeding combos or list boxes on a form) is
simple .

Sounds simple but I cant figure it out I have a form with several combo
boxes, a text box and a button. Thats all done and working. Now I want to
attach 'on click' code to the button that will put all the users selected and
entered data from this form into a new line of a table. This table already
exists. I can only do simple VBA so please be as specific as possible.
Regards Alan
I have tried many ways to connect a form to feed a table but nothing seems
to work, the otherway round (tables feeding combos or list boxes on a form)
is simple .

 

[help]

Are you set the RecordSource property in a Form

You must bounding a table with a from

or

you can use the JET SQL , jet sql code like these

currentproject.connection.execute "Insert into tablename(fieldname)
values('" & combobox.value & "')"