2 combo box questions

[Guest]

Hi,

I have created a form that has several combo boxex where users can enter
various criteria to retrieve a customized recordset.

Question #1: When I close and re-open the form the "choices" no longer show
in the combo boxes. How can I close this form and see my last selections
the next time I open the form?

Question #2: In creating the above combo boxes, in some cases I have based
the row source of one combo box on the results of another combo box.
However, the way I have set this up (which may indeed be wrong), results in
combo box #2 being empty unless a selection is made in combo box #1. Is
there a better way of handling this?

Thanks.

 

[Douglas J. Steele]

1) The only way would be to store details of the previous choices somewhere,
and then reset the selection the next time you open the form.

2) Assuming combo box #2 has code in it along the lines of "WHERE Field1 =
Forms!MyForm!MyCombobox", change that to "WHERE (Field1 =
Forms!MyForm!MyCombobox OR Forms!MyForm!MyCombobox IS NULL)"