Update field based on another field in form

  • Thread starter Sharon Milton via AccessMonster.com
  • 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
 
S

Sharon Milton via AccessMonster.com

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
 
S

Scott McDaniel

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?
 
S

Scott McDaniel

Select Case Me.Status
Case "W/D", "A", "1", "S/S"
Me.Open_Closed = "Closed"
End Select
 
S

Sharon Milton via AccessMonster.com

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