Deleting a record deletes item from combo box's underlying table

Similar Threads:

1.Deleting a record deletes item from combo box's underlying tab

thanks, Andy. I checked the primary keys on the two combo box tables: in one 
the primary key was the same as the column in the contacts table; in the 
other it was not, so I changed the PK so it matched the column in the 
contacts table.

This change did not solve the problem. The forms recordset type is Dynaset 
(Inconsistent Updates). I checked changing the value in the combo box to see 
what the change affected. I could only do this in one of the combos (I had 
the other set to Limit To List). It only affected the record as it was 
recorded in the contacts table -- not in the lookup table. (I changed that 
one to Limit to List also, after doing the test.)

Any other suggestions? (the weird thing is that this is only a recent 
problem. In past months, there have been a number of records deleted without 
this unintended side effect.)
-- 
susan


"Andy Hull" wrote:

> Hi Susan
> 
> This can happen by setting certain properties although you wouldn't normally 
> want to.
> 
> I presume the form has an underlying query and that this query gets data 
> from the contacts table and the 2 tables used by the combo boxes.
> 
> When a record is viewed in the form and deleted Access has to decide whether 
> to delete the whole record, ie all items from all tables or just to delete 
> the items in the contacts table.
> 
> To only delete contact info it has to know that the other items are just 
> "looked up" and the only way it can know this is if the query joins to the 
> "look up" tables using a primary key.
> 
> So, check the "look up" tables to see if they have a primary key and that 
> this is the column the query uses when joining from the contact table.
> 
> If this solves the problem I would also check the following...
> 
> Go to the form's property sheet - data tab - Recordset Type should normally 
> be Dynaset (yours might be Dynaset (inconsistent updates))
> 
> Also, what happens if you go into the form and use one of the combo boxes to 
> change one of these attributes?
> 
> Does it just change that contact or does it change the attribute value in 
> the look up table itself? BACKUP DATABASE before checking this!!!
> 
> hth
> 
> Andy Hull
> 
> 
> "Susan L" wrote:
> 
> > A strange problem has recently appeared -- when a user deletes a contact in a 
> > contact data entry form, items from two combo boxes on the form (that draw 
> > their values from two separate tables) are deleted from their respective 
> > tables. The delete button was created with the Wizard, and contains the 
> > following code.
> > 
> > DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
> > DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
> > 
> > I am suspicious of corruption, because I recently could not get an external 
> > report that was correct in my development database to import properly (the 
> > report changed when imported). I finally decompiled, recompiled, and 
> > compacted, and the report imported properly.
> > 
> > Should I decompile again? Is there something else I should look at? (I tried 
> > locking the two controls, but that of course meant that the selections did 
> > not write to the main contacts table, and I need to have them there.)
> > 
> > Any help would be appreciated.
> > 
> > -- 
> > susan

2.Outlook Items events don't give Delete event when you delete last item in items

The Outlook ItemsEvents interface has 3 methods:

  ItemsEvents = dispinterface
    ['{00063077-0000-0000-C000-000000000046}']
    procedure ItemAdd(const Item: IDispatch); dispid 61441;
    procedure ItemChange(const Item: IDispatch); dispid 61442;
    procedure ItemRemove; dispid 61443;
  end;

The ItemRemove event is not fired when the last item from an Items set is 
removed. It tells when when the 3rd last one is removed. The 2nd last one. 
But not the last one.

And of course, i then don't know that the last one is gone - so i try to 
access it - and get an error. 

3.Deleting text in a combo box to delete row in N:N table

4.Deleted data from Combo Box deleted table data.

I deleleted duplicate data in two of my combo boxes (in query).  When I 
finished, I saved this on my backup.  I went back in and noticed that about 
90% of my table was deleted.  

I stopped working on my database onthe hard drive and disc.  Is there any 
hope that the data can be recovered after both files were closed and saved?  
I work at a large University with a good IT department.  Do you think I 
should contact them?  

I spent 3 weeks entering this data from last year's results...and had JUST 
finished.

5.Can I delete a number of items in the deleted box,at once not all

I have a lot of old e-mails in my deleted box like form 2001, I am tired of 
doing it one at a time.  Some I do want to keep for a while.  Is there a way 
I can just mark the ones I want gone forever, and keep the rest, without 
doing it one at a time.

6. Deleted item appears in "Deleted Items" every time OLK2002 is star

7. Deleted Items in a Combo Box

8. delete item from a combo box