>Hello,
>
>I want to allow the users to select a customer using a combobox.
>The customers have an unique identification number, so I want to fill the combo with the customername and the number. If the user selects a customer the combobox returns the combo Row number, and NOT the customersid.
>
>This is a big problem as all my relations work with an identification number!!!
>
>Please help,
>TIA
>
>Greeting,
>Jean-Pierre
Hello Jean-Pierre,
Ran into this before as well. In a ComboBox the Value property returns the value if character but returns the row if numberic. To make the ComboBox return the numeric value set the BoundTo property of the ComboBox to .T. It will now return the identification number chosen. Be careful how you use the Value in code though because the number is returned as a string.
Happy Coding
Colin Magee
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.