>HI Cetin.. great to hear from you. I haven't spoken to you in a few weeks.
>
>I read your post and "think" we might be talking about two different things, regarding my problem. I re-read my post and I can definately see where there is some confusion.
>
>
>After reading what you had to say,it appeared you thought the problem was that after I selected values in each of the three combos, closed the form, then re-opened the form...... the combos were no longer displaying values when I "clicked" on the combo boxes to display their list.
>
>This isn't true: If I come back to the form and click on the combos to see the values displayed in them, I can see them just fine. The combos are working perfect as far as holding & pulling the correct data, etc.
>
>The problem is, when I re-open my OFFICES form after choosing my values, the values I chose in my last two combo boxes (cmbfields & cmboptions) are no longer visable in the "viewable textbox" of the combo box. It is just a blank box. If I click on the combo boxes, I can see the values inside of them, but they aren't displayed in the viewable portion of the textbox.
>
>Is this what you thought I was referring to? If not, do you know why this would be happening?
>
>By the way, you are correct. The last two combos are being furnished data by pviews. This was the way I was taught a few months back by Erik Moore, and has alwasy worked just fine.
>
>Thanks for any additional help Cetin
>
>Jason
Jason,
Is there some code in combo.when, gotfocus or lostfocus, valid etc of another field requerying the pviews ? I mean, at first you opened the form, pviews might not be holding the data that matches to table, later another controls.lostfocus or combos.when might be requerying and filling the data making you believe it's always there.
Add this code to form.init temporarily :
select * from pview1
select * from pview2 && with correct pview names
Cetin