Hi Kevin,
I think you can do it like this:
myvar1 = Substr(mytable.myfield, 1, 2)
myvar2 = Substr(mytable.myfield, 3, 2)
myvar3 = Substr(mytable.myfield, 5, 2)
myvar4 = Substr(mytable.myfield, 7, 2)
myvar5 = Substr(mytable.myfield, 9, 2)
* Then you must have the ControlSource of your combo with the tables and fields
* (if your combo has values at your BoundColumn that match, i think it appears OK; at least, i've already done it)
Thisform.cbo1.Value = myvar1
Thisform.cbo2.Value = myvar2
Thisform.cbo3.Value = myvar3
Thisform.cbo4.Value = myvar4
Thisform.cbo5.Value = myvar5
Say something,
Ricardo
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement