Can not go to new record using buttons on form

[Jim H]

I have a Access program that I have used for 10 years with out problems. The program is used to track work done for various customers. When I try to go to a new record for the customer using the New Record Button on my form, the program stopped and I got a Microsoft error saying it had encountered an error and needs to close. No error Number shown. I can use the Last Record button with out problems, but when I hit Next Record i.e. new record, again I get kicked out. I have tried to trap the Error Number with no luck. I have purged a lot of early records thinking possible the data base was to large - no luck. I have deleted the data for the last two customer jobs - no luck. I am at a lost for what I need to do to be able to use the data entry form. Any suggestions of where to start looking for the problem



Thank You Jim H

[kazaccess]

It could be possible that the button is corrupted. It's happened a few times to me. Open up the form in design mode and check the properties of the button. Is the "On-Click" event an Event Procedure or Embedded Macro?

[Jim H]

The "On-Click" is an Event Procedure. I have looked at the VBA code several times and can not find any problems. Following is the code.
Private Sub NewJob_cmd_Click()
On Error GoTo Err_NewJob_cmd_Click

DoCmd.GoToRecord , , acNewRec

Forms![Customers]![job Data Subform3].Form.[Route].SetFocus 'added 1/22/03

Exit_NewJob_cmd_Click:
Exit Sub

Err_NewJob_cmd_Click:
MsgBox Err.Description
Resume Exit_NewJob_cmd_Click
End Sub

Thanks for your reply
Jim H

[kazaccess]

The only other things I can think of would be to 1) create a new button and copy the code into its OnClick event and see if that fixes the issue or 2) try recreating some of the code in a macro and have a button that runs the macro. This has happened to me, and I ended up having to create a macro with the exact same code as my VBA for some odd reason.

[Jim H]

Will try your suggestions and let you know what happens.

Thanks
Jim H

[Jim H]

Have tried creating a new button with new Event Procedure and had the same problem - Microsoft error failure. Have not been able to get a macro to run properly. I have buttons that take me to the Last Record, Previous Record, and Next Record. I get the same Microsoft error when I hit Last Record and then hit Next Record button.
I have a copy of the program from the previous week of data entry and it works just fine -so far(:.
Jim H

[kazaccess]

Hmmm. My very last solution would be a compact & repair. And then if not that, make sure all the data in your tables is current, and then save that file as a new one. Other than that I'm out of ideas.

[kazaccess]

Also, be sure to create a backup of your original for good measure.

[Jim H]

I've done compact and repair several times when the problem first happened. I have made back-ups. Will try your suggestion for the table. I wonder if anyone else has read or following this thread and if they would step in to help. Or maybe I posted this problem in the wrong forum.

Any way I Thank You very much for taking your time to work with me.
Jim H

[Jim H]

I have "analyzed" the three tables in Excel and did not find any problems there. Have not tried making a new table as you suggested yet. Have to go do data entry - the hard way via tables only. Do you have any thoughts as to here I should re-post this problem?

Jim H

[kazaccess]

You could try posting in the "Forms" section of these forums. That might get your issue some more specific attention.