Error Msg: You can't go to the specified record

[Guest]

Hi everyone,

I hope someone can help me with this issue. I am testing an access 2000 db
that collects information about different events/activities for a particular
program. I keep getting this error message "you can't go to the specified
record" everytime I try to modify a record (change text or add additional
info) or add a new record. The form is a subform in a tabcontrol.

Thanks in advance for your help.

 

[Guest]

I think you need to set Allow Additions and Allow Edits to Yes (on the Data
tab of the subform's property sheet). If that doesn't help, add some details
to your question. For instance, can you add records to the main form? How
are the main form and subform related (through what field), and what type of
relationship is it? Has any code been added to the controls containing the
information you want to edit? How about to the form itself?

 

[Guest]

The Allow Additions and Allow Edits are set to yes. I don't have any problem
adding records to the main form. The main form and subform are related
through an id field that is in both tables. with a 1 to many relationship
between the main form and the subform.

 

[Guest]

Is there any code in the subform? When you set up the relationship, did you
click Enforce Referential Integrity? Can you add records directly to the
table?

 

[John Doe]

If the subform is based on a query, check the results and setup of the
query. If your query is returning more than one record that matches
the criteria set up for the query, then Access may not be able to
determine which record to make editable, especially if you have other
code in the form or the controls that would conflict with making a
clean edit. So if you are using a query to populate your subform check
to be sure it is returning what you think it is supposed to.