How to start in a particular Field?

[djclntn]

Sorry, Label not defined

[alansidman]

At this point, I am out of suggestions. Really guessing. Suggest you upload a copy of your database for further analysis. Make sure to dummy up any confidential information. Run a compact and repair and then upload.

[ssanfu]

[Click on debug, and run the compile] It's sort of not given me that option (although I have seen it in the past) I followed your instructions, On Error GoTo Err_Command125_Click this part is shaded & I get a compile error -- Label not found

Sorry, Label not defined

This is telling you a label cannot be found.

On Error GoTo Err_Command125_Click this part is shaded & I get a compile error

This is an error handler - Is says: If there is an error, goto the label named "Err_Command125_Click:". But you do not have that label. (Notice the colon at the end.)

Your current code (as posted):

Private Sub Command125_Click()    
On Error GoTo Err_Command125_Click
 

    DoCmd.GoToRecord , , acNewRec
    Forms![Customers QuickInfo].CustomerID.SetFocus

Exit_Command125_Click:
    Exit Sub


End Sub  (<<-I added this)

What it should look like:

Private Sub Command125_Click()    
On Error GoTo Err_Command125_Click
 

    DoCmd.GoToRecord , , acNewRec
    Forms![Customers QuickInfo].CustomerID.SetFocus

Exit_Command125_Click:
    Exit Sub

Err_Command125_Click:
   MsgBox Err.Number & ":  " & Err.Description

  'optional - can also have
'   Resume Exit_Command125_Click

End Sub  (<<-I added this)

[ssanfu]

The line

Resume Exit_Command125_Click

will jump up to the line

Exit_Command125_Click:


This allows you to do clean up things; ie whatever commands follow, until a Exit Sub is found such as: close recordsets, delete records, roll back transactions, ect.

[djclntn]

Steve, Yes! Success!!! Thank you!!! Not to be greedy here but I posted another thread this morning under Forms if you might want to take a peak. I must thank Alan for al of his time & effort. I say this everyday, this forum & you guys are the best!!!!!!!!1