Form opens for new record but want to edit existing records

SteveL13
SteveL13 used Ask the Experts™
on
I have a form that opens for a new record via an onclick event of another form:

DoCmd.OpenForm "frmInventoryTransactions", acNormal, , , acFormAdd, acWindowNormal

But also on the is a "search" combobox.  When the user select a record from the combobox is there a way to make the form become record editable?

Or do I need two command buttons on the first form... one for new record and one for a searchable and record editable form open?

--Steve
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
use two buttons, one for add and one for edit
Distinguished Expert 2017
Commented:
And hide the search box when you open the form in add mode.

Author

Commented:
Thanks to both of you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial