Deleted Items in a Combo Box

[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?

 

[Maurice]

Have you tried me.requery? that should do the trick. You can also try
me.repaint

 

[Klatuu]

You can use either the Refresh or Requery, but do it before you change tabs.

 

[John W. Vinson]

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?

Requery *the combo box*, not the form (the tab control's Change event would
probably be appropriate, or perhaps the subform's AfterUpdate event).

 

[Ron]

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

 

[William M.]

Requery *the combo box*, not the form (the tab control's Change event would
probably be appropriate, or perhaps the subform's AfterUpdate event).

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.