Posted on 2005-05-11
Have a VBQuestion Yes/No called from the code below. I am trying to get Access to remove the TapeID (not primary key) from the record if the user selects no from the VB box, nothing is happening, tried many times with/out the brackets. any answers?
Private Sub TapeID_BeforeUpdate(Cancel As Integer)
Dim x As Variant
x = DLookup("[TapeID]", "Tapes", "[TapeID]= " & _
On Error GoTo TapeID_Err
If Not IsNull(x) Then
MsgBox "That Tape already in this database. Continue?. Click Yes to continue, No to stop", vbYesNo, "Duplicate Tape?"
If Response = vbNo Then