"Can't go to the specified record" on Add

D

Dennis

I have an Access 2003 application under development, with a SQL backend. I
have data reader and write permissions. I am able to open the linked table up
in Access and add a new record that way. However, when I click on Add New
Record (a button I cread that just does a "DoCmd.GotoRecord , ,acNewRec", I
get error 2499 "Can't go to the specified record". I cannot for the life of
me figure out WHY. Can anyone give some ideas or insights on this? I'd sure
appreciate it!

Dennis
 
D

Dorian

Does your form containing the button have property AllowAdditions set to true?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
D

Dennis

OMG! That was it! (I'd started with an unbound form, so I always set those to
OFF, since I only need Edit turned on.) Stupid me.

THANK YOU!!!

Dennis
 

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

Help again ! Can't go to specified record ?!?!? 1
Add Record command button error message 2
Inconsistent Add Record Performance 1
Error: You cannot go to specific record 4
You can't go to the specified record 2
Add new record command button not working in tabbed form 1
Add new record to master and subform at the same time. 16
DoCmd.GoToRecord , , acNewRec is not working 0

Top