Problems editing records in subform

R

reeve13

I have a form I use to enter data entry; in addition, I created a su
form so I can view the records to edit. I noticed when I click on
particular record in the subform; the data entry form does not show th
record I clicked on in the subform. Also, I tried to delete record(s
from the data entry form based on the subform but I was unable. How ca
I go about doing this?

Thank
 
J

John Vinson

I have a form I use to enter data entry; in addition, I created a sub
form so I can view the records to edit. I noticed when I click on a
particular record in the subform; the data entry form does not show the
record I clicked on in the subform. Also, I tried to delete record(s)
from the data entry form based on the subform but I was unable. How can
I go about doing this?

Thanks
Click to expand...

Are the Form and the Subform based on the same table? If so, you will
indeed have problems: you are (potentially) editing the same record
using two different forms simultaneously.

Why two forms? Wouldn't just one form for data entry and data editing
be simpler?

If you do want to do this, please explain the Recordsource properties
of the form and subform; and the Master/Child Link Field properties of
the subform.

John W. Vinson[MVP]
 
R

reeve13

The reason for this is I locked the form so others cannot edit the for
and created a second form to do the data entry
 
J

John Vinson

The reason for this is I locked the form so others cannot edit the form
and created a second form to do the data entry.
Click to expand...

<shrug> Then you'll have this problem. Even if the form is locked,
Access won't release the record for editing.

John W. Vinson[MVP]
 
Top