Can only edit 1 record in continuous form?

  • Thread starter Thread starter HGil
  • Start date Start date
H

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 specific
question. 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 a programmatically add a new record and set the focus there, I
can't go back and edit the other records at all. The problem persists
if I use Datasheet view.

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

Thanks,
HGil
 
I dont know , but as an idea create a form with a control on it that contains
the primary key of the inspection. then insert a sub form for the Details
linked to this control on the main 'parent' form. With this arrangement
Access will do the work for you ... ;)
 
This don't sound right.

I would check the allow additions, and also make sure the forms "data entry"
is set to "no".
(if you by accident set "data entry" to yes, then the form only works for
new records).
The problem is that if there are previous
Detail entries I can only edit the first in the list - the others are
inaccessible.
Click to expand...

You cant click on those toher reocrds....or are they just not viisable???

Something is wrong here....

Try building a new continues form with the wizard...and see how that
works....
 
Back
Top