OK, tried as you suggested, but it's getting error messages. Here's
what I have:
Private Sub Incident_Number_BeforeUpdate(Cancel As Integer)
End Sub
' Update IncidentLog Number based on value selected in Incident
Location combo box.
If Me.IncidentLog = "Wichita" Then
Me.Incidentnumber = Me.wichita
ElseIf Me.IncidentLog = "Tulsa" Then
Me.Incidentnumber = Me.tulsa
Else
Me.TRIR5 -0 = Me.IncidentLog
End If
End Sub
The table is IncidentLog and the random autonumber should be picked
from within this table from a column named IncidentNumber. This
should then be placed in one of the three combo boxes labeled WIR5-,
TIR5- and TRIR5- based on the selection I made in IncidentLog, e.g.
Tulsa, Wichita, Tucson.
It's just not working. Thanks for your help in advance.
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
