
Programatically changing Form from Data Entry mode to Edit mode
Hello,
I've tried everything I can think of, but I'm sure there is some simple
form method
that will do what I'm looking for. I'm using Access 2.0.
I have a combo box that has Limit-to-List set to "Yes", and lets the
user add
a new record by coding the Not-In-List event to bring up the form in
data entry mode. The user is then allowed to add a new record. This
works
fine. Now my problem: How do you now bring the form back up in the
Edit mode, once
the user has completed and saved the newly entered record so that all
existing records
are then shown. I've tried using the Docmd Openform method using the
intrinsic constant
A_Edit, nothing happens........I've tried a macro with the
"ShowAllRecords" command
.....this somtimes only yeilds a "Stack Overflow" error. I've used both
the Me.requery and Me.repaint methods - still in data entry mode.
What's left short of creating a separate data entry form and just
closing it?
Van