you can't go to the specified record

G

Guest

I have a form based on a query which involves three tables. All three tables have primary keys defined and their relationships are set up correctly (I think) in the query. When the form is opened via a macro, the command GoToRecord New prompts the error message: "You can't go to the specified record. You may be at the end of a recordset." The macro fails, and when you click on the "Add a new record" button on the form, the same error appears. The form's properties allow for edits, additions, etc. Any ideas?
 
S

StCyrM

Hi Melanie

If you open your query, does it allow you to add a record? If not, you may
have a problem with your joins.

Best regards

Maurice
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error: Cannot got to specified record. Access 2007 and SQL 2005 1
SQL 2005 Databound Form 2
You can't go to the specified record 4
Can't edit subform - main form should not be edited. 2
Access Access 2003--you can't go to the specified record 0
You can't go to the specified record (acNewrec) 3
You can't go to the specified record ? 2
Can I change the "You can't go to the specified record" message? 11

Top