Subform errors

[cram]

Hi all,
I'm a new Access user having a difficulty with a form. I have two combo boxes in a form [Project Manager] and [Project]. [Project] adjusts based on the user input of the first combo box, and the user selection of the [Project] combo box displays the corresponding records in a subform below.

However, the subform data adds or deletes records when the combos are changed multiple times without closing the form. The subform currently pulls data from a query with criteria from the 2nd combo for which I have also used the "requery"event "AfterUpdate" of the 2nd combo. I have also set the subform to not "AllowAdditions" or "AllowDeletions". Any suggestions or input would be appreciated.
Thanks,
Cram

 

[jgoodman00]

Would it not be possible to use a form header/footer for record selection to do away with the subform? This could simplify things & you will then not have to worry about maintaining the link between the main & subform.

If you need to use a subform, have you tried setting the subform container itself to locked (well actually setting the locked property to True)...




James Goodman