Search results for query: *

Thanks Joe, That makes sense, but is there any way to get "10" back? or is it doomed to eternal data limbo? Even if we escaped out of it, shouldn't we still see it in the datasheet view as a "deleted" record? Thanks again for your advice. - Kris

I've developed a simple form that uses an autonumber as the key field. For reasons I don't understand, when we finished entering the 9th record and went to enter a new record, the autonumber skipped "10" and went straight to "11" so that now the number of records doesn't jive...

Dear Frustrated Student, Thank you so much!! You have solved my problem. Your first response did the trick. I had menu that allows people to rank five different opinions on a scale of 1 to 5. The last of these opinions is "other", which not everyone will choose and which I had left...

Well, I checked the code, but it seems to check out ok. It reads as follows: Private Sub Addrecord_Click() On Error GoTo Err_Addrecord_Click DoCmd.GoToRecord , , acNewRec Exit_Addrecord_Click: Exit Sub Err_Addrecord_Click: MsgBox Err.Description Resume Exit_Addrecord_Click...

Kathryn, Thanks for your response. Yes, the master table is the record source for the form. The form consists of about 6 tab sections that accommodate the different sections of a questionnaire. When the user reaches the end of the questionnaire, there are buttons to go back to the main menu...

I'm getting the following error when trying to do test data entry on a form that incorporates several combo boxes based on tables that feed into a "master" table: "You can't go to the specified record. You may be at the end of a recordset." I have checked the properties of...