Hi,

I want to do something very simple, but cannot get it working.

I have an MS Access database "Contacs", Table "Friends" with fields "Name" and "surname" and a form with textboxes "txtname" and "txtsurname" and an update command button.

All I want to do is add names and surnames entered into the textboxes into the table (friends) when the user click the update button ie.

insert into friends values (txtname.text,txtsurname.text).

Why does this not work???? It works fine when I hardcode the fields ie.
insert into friends values ("Dan","Abercrombie").