Hi,
I have a form named "setup", that consists of nothing but a bunch of interdependent listboxes. The rowsource for listbox 4 depends on selection in Listbox3, Listbox 3 depends on selection in Listbox 2, etc. The form works just fine, except that when I close it I often (but not always) get asked to enter one or more parameter values for:
forms!setup!ctlassy
forms!setup!bomstouse
forms!setup!ctlproduct
All of these refer to valid listbox controls on the form, and all of these are, at some point, used as part of the rowsource for one or more listboxes. Sometimes I get asked for one of the parameters, sometimes two, sometimes I get asked for the same one twice. And then sometimes I don't get asked at all.
Why oh why is the form asking me for these parameters when I close it???? There's nothing in the OnClose event. There's no error being generated.
I've repaired and compacted the database.
Using Access 2002.
I have a form named "setup", that consists of nothing but a bunch of interdependent listboxes. The rowsource for listbox 4 depends on selection in Listbox3, Listbox 3 depends on selection in Listbox 2, etc. The form works just fine, except that when I close it I often (but not always) get asked to enter one or more parameter values for:
forms!setup!ctlassy
forms!setup!bomstouse
forms!setup!ctlproduct
All of these refer to valid listbox controls on the form, and all of these are, at some point, used as part of the rowsource for one or more listboxes. Sometimes I get asked for one of the parameters, sometimes two, sometimes I get asked for the same one twice. And then sometimes I don't get asked at all.
Why oh why is the form asking me for these parameters when I close it???? There's nothing in the OnClose event. There's no error being generated.
I've repaired and compacted the database.
Using Access 2002.
