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