Delete record from Multi-value field

  • Thread starter Thread starter Dee
  • Start date Start date
D

Dee

When a record is deleted from a table, a number appears in the form field
where the record use to be. Is there a way to remove the record without
having to uncheck the box?

For example, I may have a mult-value field in my form with apples, oranges
and pears selected. If i delete oranges from the underlying table, I want it
to also be removed from the list - currently when I do this the id number
will show in the list and on the form - like this: apples, pears, 31
 
I do not use multi-value fields but here is a guess - Your main table stores
an ID instead of Oranges and when you removed the lookup record it has got to
show something so it displays the ID because the text is gone.
 
Thansk for input,

I tried as a text box without the id, and i was still left with the item
name after deleting. My client wants the item to disappear from the drop
down lsit and the form altogether once the user has deleted the item from the
underlying table.
It seems like the only way to remove it, is to uncheck the item in each
record.

Anyone know if it is possible to remove without having to do this?
 
Back
Top