i'm using a form with a subform to retrieve records that i want to either update or add new. i'm using the subform to list the pertaining records associated with a project and i want to be able to edit those records inside the subform. i currently have a cancel button on my main form to undo any changes but that doesnt work on my subform is there a procedure or something that i can do to undo my changes in the subform from the main form. i'm currently using a cancel button with this procedure:

    If (Me.Dirty = True) Then
        Me.Undo
    End If
    DoCmd.Close acForm, Me.Name

Refering to sub form controls is dicey. Is there a reason to do data entry in a sub form? It sounds like it is a data sheet sub form, which makes it even more difficult.

The problem with referring to sub form controls is naming them properly, then taking the Control.OldValue and replacing the new Value without replacing it in every other control on the sub form.

I would consider a design change. What does the sub form look like?


mmcdonal

Look it up at: http://wrox.books24x7.com

The subform displays columns (datasheet view). unfortunately i'm creating tables from data that is 30 years old or older and working with current data so i dont have the luxury of starting fresh with new data so i have to conform to the way the records were kept. in my line of work its possible to have multiple "recording numbers" per one project number so i created a table that allows you to enter a record for each recording number so that means there could be multiple project numbers assigned to different "recording numbers" inside of the table. so my attempt is to enter the project number and have it retreive all the associated "recording numbers" with the project so they can be edited in the event of a data entry error or if there is an update to the recording number.