I'm trying to open a form with a value in the a combo box.
From my switchboard, I'm opening a form called frmQuotations record source tblquotations.
this form has a combox box called cborefsaletype with control source refsalestype.
the combo box has bound column = 1
and runs a query SELECT tblSalesPackage.SalesID, tblSalesPackage.SalesType FROM tblSalesPackage ORDER BY tblSalesPackage.SalesType;
That way when you click on this combobox a list of "Saletype" opens (export, multijobs, domestic...)
what i'd like to do is to open my form with an already selected salestype in the combo box
how can i do that?
From my switchboard, I'm opening a form called frmQuotations record source tblquotations.
this form has a combox box called cborefsaletype with control source refsalestype.
the combo box has bound column = 1
and runs a query SELECT tblSalesPackage.SalesID, tblSalesPackage.SalesType FROM tblSalesPackage ORDER BY tblSalesPackage.SalesType;
That way when you click on this combobox a list of "Saletype" opens (export, multijobs, domestic...)
what i'd like to do is to open my form with an already selected salestype in the combo box
how can i do that?
