Deleted Items in a Combo Box

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

Hi,
I have a form with several tabs and each referencing a subform. Each subform
has a different table as the record source. When a row is deleted from the
table in subform 'A' a combo box in subform 'B' will show '#deleted' for
that item when I switch tabs. I use the 'refresh' method to corrected display
added items, is there nanyway to prevent the '#deleted' from appearing?
 
Hi,
I have a form with several tabs and each referencing a subform. Each subform
has a different table as the record source. When a row is deleted from the
table in subform 'A' a combo box in subform 'B' will show '#deleted' for
that item when I switch tabs. I use the 'refresh' method to corrected display
added items, is there nanyway to prevent the '#deleted' from appearing?
Click to expand...

Requery *the combo box*, not the form (the tab control's Change event would
probably be appropriate, or perhaps the subform's AfterUpdate event).
 
Thanks for responding. I tried each of the suggestions to no avail. When I
tried to requery the combo box on the tab control's Change event (using
Docmd) I received an error that it was not available.
Thanks
 
Requery *the combo box*, not the form (the tab control's Change event would
probably be appropriate, or perhaps the subform's AfterUpdate event).
Click to expand...

I have the same problem. I've added me.requery to the form Activate,
combobox Got Focus, combobox On Click. It still shows #deleted.

The only workaround I've found is to restart Access.
 
Back
Top