Re: combo box issue (1 Viewer)

[alicejwz]

Re: combo box issue

I have a combo box in a form. It display two fields-[Company], [contact] when user clicks on it.
MY problem is when user clicks on it , it replaces [Company] with [cust id] in [tblcustomer ];
Form’s recordsource links two tbls
If I remove Company in the combo box’s Control source the field will be empty when it opens up.

Thanks for your assistance.

Combo box’s property
Control source: Company
Rowsource: SELECT [cust id], [Company], [contact] FROM [tblcustomer];
Coumn count: 3
Column width: 0”; 1.5";1”
Bound Column: 1

 

[simongallop]

Think change bound column to 2

 

[alicejwz]

Re: Combo box issue

Hi Harry,

Thanks for your reply. It works w/ bound column to 2. But could you explain why bound to column 1 not working?.
Thanks!

 

[alicejwz]

Re: combo box issue

changing to bound to column 2 works but doing that will add the same customer in customer tbl when user insert a new record. Since the setting controlsource of the combo box points to Company. But If I don't the customer name(cboCompany) will be blank on all records.
form's recordsource links customer tbl & customer issue tbl. What I want is when the form opens up it will display all customer issues w/ customer name(customer tbl).

customer tbl: cust id, company,contact, address,..
customer issues: id, cust id, date, problem, action...

Combo box’s property
Control source: Company
Rowsource: SELECT [Company], [contact], [cust id], FROM [tblcustomer];
Coumn count: 3
Column width: 1.5";1”, 0.5”
Bound Column: 1