If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can only edit 1 record in continuous form?
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 |
#2
|
|||
|
|||
Can only edit 1 record in continuous form?
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 ... |
#3
|
|||
|
|||
Can only edit 1 record in continuous form?
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. 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.... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.members.shaw.ca/AlbertKallal |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
New record created in table when trying to edit displayed record | cleongatl | Using Forms | 0 | August 30th, 2005 10:01 PM |
Need to clear controls of Filter form | Jan Il | Using Forms | 2 | November 28th, 2004 02:04 PM |
Cursor Positioning | Colin Hammond | General Discussion | 3 | November 2nd, 2004 08:42 PM |
Open form, Edit button, etc | Aniko | Using Forms | 14 | July 25th, 2004 08:17 AM |
Form in Edit Mode | JN | Using Forms | 0 | July 12th, 2004 05:47 PM |