you can't go to the specified record

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
Back
Top