Rex,
I have had troubles with comboboxes and integer keys in the past until I created a class to handle it. You set boundto=.t. and boundcolumn property accordingly on the class property sheet. I usually let the first column be the one I want to show in the display, and col 2 be the integer key or boundto column. What the class does is create a temporary cursor using a "select into cursor nofilter" statement. I set rowsourcetype=2 and rowsource=cursorname after I create the cursor. It seems to me that when I switched to using rowsourcetype=2 many problems went away. This will only work if the combobox does not allow values to be added to the list. Does this help?
tc
>All,
>
>I have a simple form containing a Combobox. The RowSourceType is 6. The RowSource is 2 fields, a description field and an integer key field. The ControlSource is a form property whose value is one of the key fields. When I run the form, the Combo is initially blank. When I make a selection all behaves as normal. If I change the Form property to the record number and run the form, the cooresponding record is selected and displayed.
>
>I know I am missing something simple and I seem to remember something about integer keys, but I don't know what it is.
>
>Help!
>
>TIA
>
>Rex
Précédent
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