How To Prevent User From Navigating Continuous Subform?

[PeteCresswell]

Got a parent form that has a subform that lists "Accounts".

Once the user decides to put the form into "Edit" mode, I don't want
them moving from account-to-account.

Instead, they need to do whatever editing they want on the currently-
selected account and then either save it or cancel the changes -
reverting to "Browse" mode either way.

I've tried curForm.DefaultView = acDefViewSingle, but MS Access
isn't buying it unless the form is in "Design" mode.

Was hoping to find a "Cancel" parm in Form_Current(), but no luck.

Am I maybe missing some other event? Something functionally
equivaluent to "BeforeForm_Current()"?

Other strategies?

 

[Maarkr]

may not help you but I might try building a new form based on a query that
has the main + account data the user has selected, so when you hit edit the
form pops up then closes (and requeries) when done editing the one record.

 

[PeteCresswell]

may not help you but I might try building a new form based on a query that
has the main + account data the user has selected, so when you hit edit the
form pops up then closes (and requeries) when done editing the one record..

I like it.!

User clicks "Change", multiple-record subform rendered invisible,
single-record subform in same location becomes visible.....

Why can't *I* think of this stuff? No responses please..... -)