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 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