|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hi
Thanks for all the advice i thought this would do the trick but even if i dont type in a duplicate number I get the message You have entered a duplicate npan number. Please check your records", can anyone help im so close " I think" __________________________________________________ ______________ Private Sub npan_elec_AfterUpdate() On Error GoTo Err_npan_elec DoCmd.RunCommand acCmdSaveRecord Err_npan_elec: If Err.Number = "3022" Then MsgBox "You have entered a duplicate npan number. Please check your records", vbOKOnly Me.inv_no_elec.SetFocus Me.npan_elec = Null Me.npan_elec.SetFocus Else: MsgBox "An unforseen error has occured please contact your admisistrator", vbOKOnly Me.inv_no_elec.SetFocus Me.npan_elec = Null Me.npan_elec.SetFocus End If End Sub |
![]() |
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > code to enter my message not working |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|