To Add Record

[alem]

Alem:

Hi freinds
I worte the code like below but I coudn't add record in VB what is wrong with code please suggest me or correct me if there is error.

Thank you in advance

Private Sub cmdAdd_Click()
On Error GoTo Err_cmdAdd_click
    Docmd.GoTo Err_cmdAdd_click
    Me.Refresh
Exit_cmdAdd_Click:
 Exit Sub
Err_cmdAdd_click:
 MsgBox Err.Description
 Resume Exit_cmdAdd_Click
End Sub

[willakawill]

Hi. Your code is a living example of why goto statements are best avoided. Nothing happens in your code because of your goto statements.

If you are using vb and not access, are you using bound or unbound controls?

[devonknows]

Hi. Your code is a living example of why goto statements are best avoided. Nothing happens in your code because of your goto statements.

If you are using vb and not access, are you using bound or unbound controls?

Might sound like a stupid question but more than liekly is... why are GOTO commands such a pain in the erm ... well ya know... i admittidly have had serious problems wen trying to use them for my error handles, also what could you suggest for an error handle cus i usually put

On Error Goto ErrorHandler
 
{Code Here}
 
 
ErrorHandler:
 If Err.Number = "blah" then
    etc
 end if
 

could you suggest anything to replace or another method that would be of any use ?

Kind Regards as always
Devon