HELP - Disable the event that updates a record in a subform (1 Viewer)

MightyCat

Registered User.
Local time
Today, 10:02
Joined
Sep 11, 2012
Messages
17
Hi need HELP! I have a subform based on a linked table that is to a SQL view. I found yesterday that if the SQL view has more than 2 tables joined, you can updated the linked table. SO -- I need to do the update manually.

What is the events I need to put the update statement under when the user moves to a different record ? I also need to disable the automatice updating of that record since it gives me the error that you can't update the query/function b/c it has mulitple sources.

Thanks!:banghead:
 

boblarson

Smeghead
Local time
Today, 10:02
Joined
Jan 12, 2001
Messages
32,059
You would issue a

CANCEL = True

in the form's Before Update Event but would also need to do a

Me.Undo

to let it continue to the next record.
 

Users who are viewing this thread

Top Bottom