I'm probably not the best person to answer this question, since I've had my share of problems with cbos! But, it's been my experience that it's easier to use a numeric field as the BoundTo field rather than a character, in fact I avoid character fields in this situation whenever possible. Now, that doesn't mean it can't be done, it's just not as straightforward and since I've been avoiding coding cbos in that manner, I'm not sure what to suggest what your problem might be. Is there any way for you to use a numeric BoundTo field?
Sorry I wasn't much help,
Bonnie
>hello everyone >:
>
>Background:
>
>I have a form called OFFICES that I have recently placed three combo boxes on. They are as follows:
>
>A. cmbsourcestate
>column count = 1
>bound = 1
>bound to = .t.
>control source = offices.csourcestate
>row source = AL,FL
>row source type = 1 value
>
>B. cmbvotercode
>column count = 2
>bound = 2
>bound to = .t.
>control source = offices.cofficefield
>row source = voters_field_pview.cfieldlabel,cfieldname
>row source type = 6 - fields
>
>C. cmboption
>column count = 2
>bound = 2
>bound to = .t.
>control source = offices.cofficeoption
>row source = voters_options_pview.cfieldlabel,cfieldoption
>row source type = 6 - fields
>
>Situation: These three combos are related in that I have code in the interactivechange event to make sure the appropriate data displays when a certain selection is made.
>
>Problem 1. After I select my values and exit the form, and then come back to the form to do some more data entry, cmb boxes B & C are not displaying the values I placed into the combo box anymore. If I go to my offices table, I can see the table is storing the correct information that I selected, but it isn't visible when I get back to the form.
>
>Problem 2. I get an error message that says "record out of range"
>
>
>If anyone has any advice, guidance, insight, etc. ... I would sure appreciate the help.
>
>Thanks
>Jason