Can't go to specified record message

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I've created a form to view data from a query. Main table
is using a lookup field to get client number from client
table. Query using client number from 2nd table and
getting client name from client table based on client
number. The problem is that in the query or in the form I
cannot add a record. I get "Can not go to specified
record" message. Any ideas?
 
Hi,


That is probably because the actual record is dirty and cannot be saved.
You know Access try to save a record, automatically, when you change of
record, and if the actual one is modified, or new, but violates a rule
(anyone), the record can't be save, and so, Access can't move OUT of the
actual record to go to any other "specified record". Correct the data, or
abandon the changes (Me.Undo) before moving.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top