Update field based on another field in form

  • Thread starter Thread starter Sharon Milton via AccessMonster.com
  • Start date Start date
S

Sharon Milton via AccessMonster.com

Hi there,

I have a db of documents (tblDocuments), that have many revisions
(tblRevisions).

I need the previous field [Current_Status] on the Revisions form to update
automatically to S/S (Superseded) when another revision is entered and the
current revision to read CR (Current).

Any help would be appreciated.
regards
Sharon
 
Also have this code to update another field but getting an runtime error 13
"type mismatch", both fields are text fields - thanx in advance.....

Private Sub Status_AfterUpdate()
Select Case Me.Status
Case "W/D" Or "A" Or "1" Or "S/S"
Me.Open_Closed = "Closed"
End Select
End Sub
 
How do you determine which is the superceded revision? IOW, if you have 3
revs of a document, how do you know which one was the first, second and
third? Do you have date or time stamps in tblRevisions that would indicate
this?
 
Select Case Me.Status
Case "W/D", "A", "1", "S/S"
Me.Open_Closed = "Closed"
End Select
 
Thanks for the above Scott.

The superseded could be assessed on Date_Sent, as this appears to be the
only date that consistently changes upon each revision.
 
Back
Top