Should be easy, but I'm missing it

[WadeD]

I'm sending an INSERT SQL statement to add a record:

'Error --> Too Few Parameters:
INSERT INTO [MainRep] ([Service Description]) VALUES ("CAN'T");

I used the quotations around CAN'T because of the apostrophe, and this works great in Access (I copied and pasted to make sure), but I get an error in VB. Where am I going wrong??

Thanks in advance,
Wade

[This message has been edited by WadeD (edited 01-26-2000).]