Use code to Change Form DataMode from acFormAdd to acFormEdit

I have a form (which is opened by a Not In List event in another form) which opens in DataMode:acFormAdd  
I'd like to create a control button on the form so that the the user can switch to acFormEdit.

Can it be done?  What code do I need for my control button?
LudiqueAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Ludique,

You have to make sure this is what you want.

The form "probably" opens in acFormAdd mode so you can enter a new item for the list.
While in add mode you can edit the current record.

Lots of strange things can happen if you change the From mode at the wrong time.

Can you explain what you are trying to do?

JeffCoachman
0
 
Jeffrey CoachmanMIS LiasonCommented:
Thanks,

But for the sake of ayone else searching here with a similar issue, can you state how my post help solve your issue?

Thanks

JeffCoachman
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.