I have a form called frmQuotations (datasource = tblQuotations) which opens with a cmd button on my switchboard.
On this form I have a combo box called cboRefSalesType which refers to tblSalesPackage
tblSalesPackage which has 2 fields: SalesID and SalesType (ex: SalesID 31 = SalesType Export)
The row source of this combo box is a query:
SELECT tblSalesPackage.SalesID, tblSalesPackage.SalesType FROM tblSalesPackage ORDER BY tblSalesPackage.SalesType;
Only 1 bound Column and it's the Salestype column you see when you click on the cbo box
that way when I click on the combo box i have the list of SalesType (Export, Multi Jobs Export, ....)
I need to code my cmd button which opens the form to return the value "Export" already selected in my combo box.
Any suggestions?
On this form I have a combo box called cboRefSalesType which refers to tblSalesPackage
tblSalesPackage which has 2 fields: SalesID and SalesType (ex: SalesID 31 = SalesType Export)
The row source of this combo box is a query:
SELECT tblSalesPackage.SalesID, tblSalesPackage.SalesType FROM tblSalesPackage ORDER BY tblSalesPackage.SalesType;
Only 1 bound Column and it's the Salestype column you see when you click on the cbo box
that way when I click on the combo box i have the list of SalesType (Export, Multi Jobs Export, ....)
I need to code my cmd button which opens the form to return the value "Export" already selected in my combo box.
Any suggestions?