2 combo box questions

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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)"
 
Back
Top