Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to display in the form combo box, two columns from the combo box

Status
Not open for further replies.

titoneon

MIS
Dec 11, 2009
335
US
Hi,
I attached a link that will show a form, that i have for data entry, in that form i have a combo1 control with a label named "Code desc" and this combo1 is bound to another table named "codedat" that has two fields named "code" and "descode", during the data entry when i select the combo box i am able to select the code i want wich is two character example "OA", and the field desc value for this OA is "machine wiring", ok at the point of selecting from the combo box i can see both columns cause i have a select sql command that will get the code and desc and will save it into the current table named "datatest", but later after the entry has been saved if use the navigation control to get back and forward thru out the records then the only thing displayed in the form combo1 is just the field value datatest.code, i can leave with but it is possible to display in the same combo1 the datatest.code + datatest.descode ?
please see if you can open the attachament, i did not know how to paste an image in this post
Thanks a lot
Ernesto

 
I said you should add the property to the container class, not to the form. When you edit your navbar class, you edit your navbar class, not the form, do you? Have a read about the oop principle of encapsulation, perhaps.

Bye, Olaf.
 
...because if you have two navbars on a form (eg on seperate pages of a pageframe) you can open and navigate two tables. That's nothing you would put on the form level, just because normally your forms are working on one main table only. Your navbar works on a single table, what your form works on doesn't matter for the functionality and stability of navbar button code.

Bye, Olaf.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top