3167 "Record is deleted" - I'm stumped

[Rick Allison]

I add a new record via the form. That works.

I requery the selection combo box and it shows the new record. That works.

I select the record just added and the form populates. That works.

I delete the record using a delete button I coded. That works.

The requery of the combo box works and the record just deleted is not shown.

When I click on another record from the combo box I receive the 3167 Error.

I've tried docmd.runcommand acCmdSaveRecord after the add but that does not seem to fix the issue.

If I put docmd.runcommand acCmdSaveRecord after the delete I receive the 3167 error.

I am stumped. What have I missed? I've search the newsgroup and have not found anything that seems to work.

Thanks,

 

[Ken Snell \(MVP\)]

Assuming that you're using the same form for the addition and deletion of
the new record, the form may still be on the "deleted" record. As such, if
the combo box is bound to a field, and you're using the combo box to add
data to that field, you'll need to move the form to a new or existing
record.

Hard to give more specific information because your description leaves many
"possibilities" for your setup and process. Give us more specific details
and we should be able to provide more details.
--

Ken Snell
<MS ACCESS MVP>




I add a new record via the form. That works.

I requery the selection combo box and it shows the new record. That works.

I select the record just added and the form populates. That works.

I delete the record using a delete button I coded. That works.

The requery of the combo box works and the record just deleted is not shown.

When I click on another record from the combo box I receive the 3167 Error.

I've tried docmd.runcommand acCmdSaveRecord after the add but that does not
seem to fix the issue.

If I put docmd.runcommand acCmdSaveRecord after the delete I receive the
3167 error.

I am stumped. What have I missed? I've search the newsgroup and have not
found anything that seems to work.

Thanks,