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.
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.