View Full Version : Problem with Append Query


RudeYute
04-24-2006, 11:12 AM
Am trying to use a parameter query to append a record into a table.
7 or 8 parameter popups come up, for the user to insert the details. One which doesn't popup is supposed to insert the current time/date using the Now() clause (not sure if that is causing the problem).

When I insert items into the fieldboxes, I try to append, but then get the attached error, not sure why.

I was told that the error occurs when a primary key is used, but that is not the case.

Anyone help please?

Thanks

DocNice
04-25-2006, 02:45 PM
You don't have a primary key on the table you are trying to append?