View Full Version : problem with sub-form delete after XP upgrade


irad
09-05-2001, 07:54 AM
I created a relatively complex rolodex program many years ago which has survived many upgrades of Access. I'm not a programmer and created the database through use of macros and forms. Basically the database is relational, with a list for companies and a list for people. On the companies page, there is a sub-form that lists the people who work there, with buttons next to each one to connect to their personal informtion. On the people page, you can select as many company associations as you'd like, and those companies records can be accessed by pressing the buttons next to them. Companies are selected on each line of the subform through a combo box so the record has to exist before it can be added to a person's card. since the relationship is many to many, there is a table in between that holds the associations. Anyway, all works well except one new quirk that has developed since upgrading to the XP version of Access-- which is that I used to be able to highligh a line on the subform that conatins the company associations, press the delete key, and that company's association would be deleted from the person's record. Now, whejn I do that, it appears to disappear from the record, but when I save it, the association is still there. I can change the record through the combo box to another company--that workd fine! But, I cann just delete it. So the net affect is that as long as the number of associations remains constant (someone shifts from one company to another) things are fine, but if I want ot reduce someone from three companies that they are associated with, to two, I cannot do it.

Any ideas?