Hi,

I have one table which has about 7 to 8 fields, except first, all fields are getting values from user form.

Now first field is ID (Autonumber),
How do i specify that value in my INSERT INTO <Table Name> ... query?

I tried INSERT INTO (XX,YY,AA..(FIELDS NAME)) VALUES (VALUES...)
 but gives the same error as "Parameters are not matching.."

I know it gives error becs i have not specify ID(AutoNumber) value.

Can anyone pleas help?

Thanks in Advance.
Rupen.

Rupen Anjaria.:)
------------------
It is not difficult to be on TOP...It is difficult when you carry Truth,Commitment and Transparency with you.

Kindly Ignore this...

Rupen Anjaria.:)
------------------
It is not difficult to be on TOP...It is difficult when you carry Truth,Commitment and Transparency with you.