adding record in table Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a form for adding record in table, in this form, there is a macro to
reset value in it. When I try to add a new record the following massage
appears and I can not add record†YOU CAN NOT GO TO THE SPECIFICED
RECORDâ€.Can any body help me please?
Thanks
 
Hi,
I have a form for adding record in table, in this form, there is a macro to
reset value in it. When I try to add a new record the following massage
appears and I can not add record” YOU CAN NOT GO TO THE SPECIFICED
RECORD”.Can any body help me please?
Thanks
Click to expand...

Sounds like the form might be based on a Query which is not updateable. Try
opening the Form in design view; view its Properties; and select the
Recordsource property (first line on the Data tab). Is it a table? or a query?
If it's a Query, open it as a datasheet; is there a *> new record at the
bottom?

If not that's the problem. Open the Query in SQL view and post the SQL text
here and someone may be able to spot the problem.

It might also help to post the actual steps in your macro.

John W. Vinson [MVP]
 
Back
Top