RecordSource issue?

[glen]

My codes.


Private Sub Combo7_Enter()
If Nz(Me.Combo7, "") = "" Then
DoCmd.GoToRecord , , acNewRec
End If
End Sub

Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub

[glen]

Ohhh I forgot to tell you that when this problem happen.
check attachment of post no.1 https://www.accessforums.net/forms/r...tml#post130060
I changed combo box of Location into text box.
from then this problem occur

[RuralGuy]

While viewing a code page go to Debug>Compile and see what happens.

[glen]

Compile command is not active.

[RuralGuy]

enter a space in a non important location in the code and then Compile.

[glen]

I did but nothing happen.
where i put space the cursor go there.
I also put space in unimportant location then nothing happened.
But database is working properly now.for the last one hour i opened my database many time but the error message not coming now.
can you tell me about "on error go to." code?
Is it important for every vb programming codes?
and what is it procedure?

[RuralGuy]

When you put in the space, did it enable the Compile?

[glen]

yeah in some places when i put space it enable compile.

[RuralGuy]

And then it compiles without error, correct?

[glen]

yeah compile without error.

[RuralGuy]

Here's a good article on Error Handling: http://allenbrowne.com/ser-23a.html