Can't edit more than 1 record in form?

[HGil]

Hello All,


I've got Access 2003 and a problem with editing data on a form .

Project background: I'm creating an electronic inspection form for my
company's field crew as they inspect our working construction sites.
Various inspection questions are either "compliant" or "noncompliant".
On a noncompliant value, an Add Details button becomes visible which,
when clicked opens a continuous Add Details form. The button also
passes the unique inspection ID and the unique question id to the
Details form.

Problem: My Add Details form is a continuous form bound to a single
table. Through some code I'm setting the form's filters to only
display data associated with that specific inspection and that
specificquestion. The filters work great. I only see the data I'm
supposed to see on the Details form. The problem is that if there are
previous Detail entries I can only edit the first in the list - the
others are inaccessible. I can never get the focus to move past the
first record. If I programmatically add a new record and set the focus
there, I can add that single record, but I can't go back and edit the
other records at all, or add additional new records. The problem
persists if I use Datasheet view.

Any ideas on what is happening and/or what I can reference for help?


Thanks,
HGil

 

[John Vinson]

Any ideas on what is happening and/or what I can reference for help?

Sounds like the "Allow Edits" or "Data Entry" properties of this form
are not set correctly.

Why the added complexity of a popup form? Might it not be simpler to
make this a Subform, so the master/child link fields can accomplish
what you're trying to do with code?

John W. Vinson[MVP]