Set value in combo box

hansnyc

Registered User.
Local time
Today, 03:02
Joined
Apr 12, 2007
Messages
50
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?
 

Users who are viewing this thread

Back
Top Bottom