Recordset error

[quepi]

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 the form and believe that the recordset property is correctly set at "Dynaset". I've also checked the controls to ensure that they aren't locked.

Quite honestly, though, I'm out of my depth on this issue as a user who has been thrown into a sink or swim database situation. Any advice on where I should start would be much appreciated. This forum has been immensely helpful to me over the course of the past few days.

Thanks for your help,
Kris

 

[kathryn]

Kris,

What exactly are you trying to do when you get the error?

As far as your form goes, just to clarify: you are entering data by choosing from dropdown boxes. The drop down boxes are based on individual tables which are related to the master table. When you choose a value from the combobox, the ID associated with the value is put into the master table. Is that right? Is the record source of the form the Master table?

Kathryn

 

[quepi]

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 (switchboard), exit the program, print the questionnaire, or add the next record. I get the error when I click the button to add the next record.

I've gone through and checked the properties on the drop down boxes to ensure that the correct columns are bound to the master table and they seem to be in order. However, do I actually need to define those relationships using TOOLS, RELATIONSHIPS? I have not done this.

Thanks for any additional insight you can provide.
Kris

 

[kathryn]

No, I don't think that the combo boxes are your problem. Your post states the the button is to add the NEXT record. I think that you want to add a NEW record. Minor difference, but major to Access. Can you look at the code behind the button and see if it uses acNewRecord or acNextRecord?

Kathryn

 

[quepi]

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

End Sub

Any other ideas? thanks again,
Kris

 

[FrustratedStudent]

I received this error also a few days ago. My problem was that I had not filled in all controls associated with the control that was taking in the answer. Once I filled in all fields that were related it allowed me to continue.

Hope this helps

 

[FrustratedStudent]

I have another suggestion
I was having this problem this morning again.
Check your linked fields between the child and master form and make sure you have all fields that you want associated linked.

Meaning your parent and subforms common fields are linked in subform properties.

Frustrated Student

 

[quepi]

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 blank when I was doing my testing. This was the culprit!

You know, I had a feeling that the solution would be something really simple like this. Now, with any luck I won't hit any more snags.

Thanks again for your help and good luck with your project.

Kris