M
Max Moor
Hi All,
I have a form with a listbox (and other controls) on it. The listbox
has it's own query for its row source. The form's record source is a query
that refers to the selection in the listbox. This way, the controls on the
rest of the form reflect detail data about the highlighted item.
The problem is that when I delete a record (in VB), then call
Me.Requery, I get a 3167 error saying the record is deleted. Sure enough, if
I look in the listbox, "#Deleted" is there. The odd thing is that if I click
on Debug when I get the error, I can immediately press F5 to run the code,
and it completes without repeating the error.
I've tried requerying the listbox before I call Me.Requery to requery
the form, but it doesn't help. The only solution I've found online was that
the database might be corrupted. I doubt this, but did a compact and repair
just to be sure. It didn't help.
I'm developing in Access 2002, by the way. Can anyone point me to a
solution?
Thanks, Max
I have a form with a listbox (and other controls) on it. The listbox
has it's own query for its row source. The form's record source is a query
that refers to the selection in the listbox. This way, the controls on the
rest of the form reflect detail data about the highlighted item.
The problem is that when I delete a record (in VB), then call
Me.Requery, I get a 3167 error saying the record is deleted. Sure enough, if
I look in the listbox, "#Deleted" is there. The odd thing is that if I click
on Debug when I get the error, I can immediately press F5 to run the code,
and it completes without repeating the error.
I've tried requerying the listbox before I call Me.Requery to requery
the form, but it doesn't help. The only solution I've found online was that
the database might be corrupted. I doubt this, but did a compact and repair
just to be sure. It didn't help.
I'm developing in Access 2002, by the way. Can anyone point me to a
solution?
Thanks, Max