I have managed to work out everything but this. PLEASE HELP!
I have two fields [current invoice] & [previous invoice]. There are two things i need to come out of this. One is that i have it set up so that onactivate if it is a new record the form autofills some fields. Using this string:
If Me.NewRecord Then
Me.FacID = Forms!frmDocumentMovementMain!FacID
Me.Date_Recieved = Forms!frmDocumentMovementAddEdit!DateIn
Me("Work Order #") = Forms!frmDocumentMovementAddEdit("WorkOrder#")
End If
I need to add an else statement that If the facID and WorkOrder# have been entered before i want a new record for the main form, using the data from the original invoice in the subform. At this point of the process i need the [currentinvoice] field to be moved to the [previousinvoice] field.
Please if you can help me with this i will jump up and down and fart pink balloons.

Well that would be interesting to watch !

Anyway. Firstly I would have the auto filled fields set up in form current. When I want to add a new record i will click on a cmdbutton which auto fills the ID, date received and works order based on whatever such as ID + x. In form current you could say if not isnull me.worksorder (or whatever field) then me.previous = me.current.

After that say if me.current = me.previous then me.current = "updated to previous" (or whatever) or then me.current isnull

Andy (sorry if i got the wrong end of the stick)