R
RobUCSD
Below is the code I use to add a staff member to the Visit Staff member list.
I need code to be able to check to see if the staff member allready exists in
tblVisitStaff (for that particular visit) and if that pt exist in the list, I
need to have a MsBox that says, "This Staff Member is Already Listed"
This is a paired listbox application.
Private Sub lstStaff_DblClick(Cancel As Integer)
Dim sSQL As String
sSQL = "AddNew tblVisitStaff WHERE fldStaffID = " & Me.lstStaff.Column(0)
Me.Refresh
End Sub
Any help would be greatly appreciated. Thanks, Rob
I need code to be able to check to see if the staff member allready exists in
tblVisitStaff (for that particular visit) and if that pt exist in the list, I
need to have a MsBox that says, "This Staff Member is Already Listed"
This is a paired listbox application.
Private Sub lstStaff_DblClick(Cancel As Integer)
Dim sSQL As String
sSQL = "AddNew tblVisitStaff WHERE fldStaffID = " & Me.lstStaff.Column(0)
Me.Refresh
End Sub
Any help would be greatly appreciated. Thanks, Rob