Open Form In Edit Mode For Current Record

  • Thread starter Thread starter Debra Washington via AccessMonster.com
  • Start date Start date
D

Debra Washington via AccessMonster.com

I have a read only form with a edit button to open a NEW form to edit the
current record. This new form is already created, but when i click on the
edit button i get an error that the table is already open and can't be
modified.

please help if you have a solution.

Thanks!
Debra Washington
 
I have a read only form with a edit button to open a NEW form to edit the
current record. This new form is already created, but when i click on the
edit button i get an error that the table is already open and can't be
modified.
Click to expand...

The record is opened already on the first form. You can't be looking
at a record on one form, while simultaneously changing the same record
on another form!

The simplest way to do this is - rather than opening another form -
simply changing the first form's AllowEdits property.

Alternatively, you can include code in the first form to move off the
record prior to popping up the edit form.

John W. Vinson[MVP]
 
Back
Top