Open Form In Edit Mode For Current Record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Debra Washington - 08 Apr 2005 02:05 GMT

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

Reply to this Message

John Vinson - 08 Apr 2005 02:50 GMT

>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.

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]

Reply to this Message