Nov 15 2006, 03:43 PM
I've been working on a problem that I cannot seem to resolve. I have an form used for editing existing records. This forms contains custom navigation buttons. If the user decides not to change any records the navigation buttons work perfectly. However, if the user does decide to change a record then when they try to use the navigation button to go to the next record, a #Deleted appears in the controls. I tried adding Me.requery on the navigation buttons but it does not work all the time. I'm attaching a scaled down version of the db so you can have an idea of what I'm talking about. I'd appreciate any help you can provide.
Nov 15 2006, 05:02 PM
It is a bit hard to follow your form, but it appears that the deleted is justified as it looks like the record is being deleted and not modified... I have not tried to go through your code as there is a bunch, so I would suggest you put a Stop in you code and find out what is happening after the pop up asks if you want to save the changes...
My three cents worth...
Nov 15 2006, 06:38 PM
I have to agree with Jack.. it's a little difficult to follow the process of the form could you can walk us through it.
Nov 16 2006, 11:01 AM
Thanks for responding. On the criteria form, the user selects the state, event, year, and the revising status and clicks the Edit Existing Record button. When the user opens the form, they can scroll through the previously entered records by using the navigation buttons. They can only change the item value or comment. If they want to change an item value for the current item, then they should click on the Change Item Value button and the list of item values will be repopulated in the item value multiselect list box. After they make their new selections and click one of the navigation buttons to move to the next record, the old values from the table will be deleted and the new values will be added.
Let me know if you need more explanations.
Nov 17 2006, 10:03 AM
I've decided to redo my form based on an earlier suggestion from Jack to use subforms. The form is working much better now.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here