Summerwind
Registered User.
- Local time
- Yesterday, 20:33
- Joined
- Aug 25, 2005
- Messages
- 91
Sorry if this has been explained elsewhere but I couln't find it.
I have a data editing form where I use several combo boxes to select the data in an Access back end.
In Access I can simply create a recordset of the data I wish to edit then set the value column in each combo to the value in the recordset. The combo will show the "Understandable by humans" data for that item.
I have learnt the longwinded method of creating the rowsource for combos in .Net and also how use ADO to create a recordset from my backend.
Now I'm tearing my hair out as to how to set the values in my combos to the data in the row of the record I wish to be edited. The compiler won't allow me implicit conversion to text because Option Strict is set to On and won't let me change that. In addition, the data isn't in any case text but an integer!
Any help would be greatly appreciated.
I have a data editing form where I use several combo boxes to select the data in an Access back end.
In Access I can simply create a recordset of the data I wish to edit then set the value column in each combo to the value in the recordset. The combo will show the "Understandable by humans" data for that item.
I have learnt the longwinded method of creating the rowsource for combos in .Net and also how use ADO to create a recordset from my backend.
Now I'm tearing my hair out as to how to set the values in my combos to the data in the row of the record I wish to be edited. The compiler won't allow me implicit conversion to text because Option Strict is set to On and won't let me change that. In addition, the data isn't in any case text but an integer!
Any help would be greatly appreciated.
