Hi,
I have a form that user can enter text which is then added to a DB table.
From the submited form, a value(found) is inserted into a table using the following query:
SQL = “INSERT INTO tblFound Values (’ “& found &” ')”
However, I keep getting an error.
Microsoft JET Database Engine error ‘80004005’
Number of query values and destination fields are not the same.
I think that it is because the form has 2 fields:
ID autonumber (pk)
Found text
I think the query needs to “skip” the ID autonumber and just insert the found value but the the DB needs to assign a number to the new value.
Any suggestions?
Many Thanks