Form edit = True but don't want to post from the form

[MightyCat]

I have a form with a source linked table which is a view of multiple tables in SQL. I know that ACCESS can't update records to a linked view that has a join of more than one table.

So, in the BeforeUpdate procedure, I update the tables directly via a stored procedure call. But, then, the form still tries to update the Linked view. How can I still refresh the dataset but keep the form from posting?

If I do Me.Undo, it clears the inputted data but also doesn't refresh the data to reflect the input if I leave the record and go back to it.

Any suggestions? I'm trying to keep from using multiple sub forms

Thanks!

 

[RuralGuy]

I know that ACCESS can't update records to a linked view that has a join of more than one table.

What makes you think this is true as it is not.