unable to goto new record

  • Thread starter Thread starter martha.dempsey
  • Start date Start date
M

martha.dempsey

I am using access 2000 and I had something similar that
dealt with indexes. If you access your table and click on
to the index icon (looks like a lighting bolt) and there
are more than 32 fields listed for your table then it will
not let you save or have the option to select a new record
(asterisk on navigator disappears). You can delete some
of the indexes without deleting your fields.

Try it on a copy first to see if that is what you need.
martha
-----Original Message-----
Hello,
i have a subform which has a command button on it that fires the action:
docmd.goto , , acnewrec
This subform has also an error trapper in the form error event
Me.controls(subform_name).form.recordset.addnew

If i insert a record with duplicate values for the
Click to expand...
primary keys the form error event happens ONLY if i use
the command button on the main form.
If i act on the command button on the subform a msg just
Click to expand...
says that "You can't go to the specified record".
For what i can see the form error event doesn't happen
Click to expand...
(so my error trappers fail...) acting on the command
button on the subform. Why?
Click to expand...
 
Thanks for you rreply but i dont' think is an "index thing"
I can add new records without any problems
I have a mani form which has a subform. I use the subform to enter data. On the main form there is a command button named "SAVE" which us
me.controls(subformname).form.recordset.addne
To go to a new record. The subform itself has a command button named "ADD" which does almost the same thing, but us
docmd.goto,,newrec
Both works fine when I add new records, but... let's say i insert duplicated values for the primary key's fields..
When i use the command button "SAVE" on the main form the form error event is fired for the form relying the subform. If i use the command button "ADD" in the subform, the form error event doesn't fired. In the form error event i have code which manage the error 3022 for duplicated values of primary key which gives me option to cancel/retry operation (changing values in controls). The command button "ADD" also has an error handler, not specific for the case of error 3022 because i guess it was handled by the form erro event. I dont' receive the msg from the error event routine but from the add_click routine (which is generic and doesn't explain what's the matter)
Hope this is more clear, i'm italian and not so good with english
Thanks anywa
Nico
 
Back
Top