How do I use the INSERT INTO Statement in VBA?

From: "Unique Name" <Unique Name@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 28 Jul 2005 14:10:02 -0700

I am trying to enter data into a table from a form using the INSERT INTO
Statement in VBA forAccess 2003. I type it as shown in the assistance(below)
but keep getting errors. Is there something I am missing?

INSERT INTO target [(field1[, field2[, ...]])]
VALUES (value1[, value2[, ...])

Thanks
.

Follow-Ups:
- Re: How do I use the INSERT INTO Statement in VBA?
  - From: David C. Holley
- RE: How do I use the INSERT INTO Statement in VBA?
  - From: Ofer

Prev by Date: Re: VBA Function Exits Unexpectedly
Next by Date: i cant open the window to microsoft office word viewer help
Previous by thread: Creating a custom date field
Next by thread: RE: How do I use the INSERT INTO Statement in VBA?
Index(es):
- Date
- Thread