I tried your suggestion, but I could not make it work. I must have needed to do something else. I tried several variations and tests. I put THIS.Value in the Init. And I set BoundTo to .F. and I also filled in mytable.myfield as the ControlSource. And set RowSource and RowSource Type to none.
After no good testing, I left the above settings alone, except for ControlSource and then here's what I finally did to get it to work.
1. Valid method -
REPLACE mytable.myfield WITH This.Value
2. Refresh method -
THIS.DisplayValue = mytable.myfield
3. Changed the myfield in mytable from Char size 1 to Num size 1.
4. Set ControlSource to none (Default).
Now it works and it saves a single position numeric digit. This makes me wonder why I save a code that matches a description when the Index number could be the code for the description and I wouldn't have to define a code for each and every description.
This also makes me think that when I convert my old table into my new table with codes in fields for descriptions (someone saved whole descriptions in the old version of myfield and mytable) I could save myself tons of work in the conversion program, but I have to think it through. It's a lot of fields to convert from full descriptions to codes. Maybe I defined all of those new codes for nothing when I could have just used the Index number to auto generate the code for the description. Does this make any sense? Now I am really confused.
Thanks for your help always. I have 9 FoxPro books here at my disposal, but you guys are better than books any day. But I have to admit the books are still a necessary tool.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site:
www.stephenkramer.comWould you believe Far Side Lite?
More than 270 original cartoons.