Append Query to Override

  • Thread starter Thread starter mattc66 via AccessMonster.com
  • Start date Start date
M

mattc66 via AccessMonster.com

I have an append query. If it finds a record already I want it to override.
It appears to just ignor. How do I override in my Append Query?
 
Hi Mattc66

You will need to alter the way your append query is called, as an append
query will add a new record every time (hence the name append).

In code behind where you are calling your append query, do something like
this:

if <check that record exists> then
' record exists - use update query
else
' no record - use append query
endif

You could check that the record exists by doing a dlookup as necessary.

Hope that helps.

Damian.
 
Back
Top