• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1308
  • Last Modified:

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?
0
Ludique
Asked:
Ludique
  • 2
1 Solution
 
Jeffrey CoachmanMIS 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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now