Autonumber and insert into statement.
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.
It is not difficult to be on TOP...It is difficult when you carry Truth,Commitment and Transparency with you.