Duplicate records , no error message

[bradcccs]

What does your Macro "IPR - View current list - View all" do?

I can not see any actions here that would cause records to be removed from your User_Log.

(I can't see the error trapping either though. Is this the same form?)

Brad.

 

[NOL]

Hi Brad !!!

The code worked !!!
DoCmd.GoToRecord , , acNewRec

Now my USER_LOG table is being updated correctly , I can start with error trapping ! Whew!

The "View All" macro just opens a form based on a filtered query.
Yes nothing gets deleted , i think accmdsaverecord just writes to the current record , though i cldn't be sure


Now i will put in my error trapping code ,
I hope u'll be around, coz i'm dfinitely gonna stumble again ,

u've been a great help!
Thanx,
Gina.

 

[bradcccs]

 

[Mario]

Gina,

Have you been able to figure out why an "INSERT" clause will not bring up any error message when trying to insert a duplicate value?

Right now I can't know if there was any duplicates that have not been added with the "INSERT" clause. I read your whole post but it is not clear to me how you solved this problem.

Thanks

 

[NOL]

Hi Mario ,

No I don't.
I cldn't figure it why the INSERT didn't work .

Gina.

 

[Mario]

One of the unsolved mysteries. Thanks anyway, I appreciated your quick reply.