Programatically changing Form from Data Entry mode to Edit mode 
Author Message
 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



Mon, 29 May 2000 03:00:00 GMT  
 Programatically changing Form from Data Entry mode to Edit mode

Van,

How about just a requery on the combo box control...

eg.  Me!cmbName.requery

This works in Access 95...

Hope this helps,

Todd Lutton



Mon, 29 May 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Jet 3.5 Edit mode or AddNew mode

2. change from running mode to design mode

3. Trigger Edit Mode on First Change

4. Checking For Changed Fields During Edit Mode

5. Checking For Changed Fields During Edit Mode

6. Edit Mode with Data Environment

7. Edit Mode with Data Environment

8. Edit Mode with Data Environment

9. Data Control: Determining Edit Mode (state)

10. Edit Mode with Data Environment

11. Switch Form Between Edit and Add modes

12. Form size changes in runtime vs design time modes

 

 
Powered by phpBB® Forum Software