Tried it.. and it didnt work. I can see that the variable is changing from 1 to 2 so the query should filter. Its just not requering..

Chris




>Hi Christopher,
>
> Try doing the requery in the interactivechange event of the first combo box.
>
>Hope this helps,
>Gavin...
>
>>I have a small table of insurance companies and a child table of all the plans offered by the insurance companies. I have 2 combo boxes on a form one of the insurance companies, one of the plans. I want the user to select the insurance company in the first combo box and then have the second combo box limited to that company's plans.
>>
>>The first combo box on click throws its value (the number of the insurance company) to a memory variable. The second combo box is based on a local view of the plans table which filters by the variable that the first box stores its value to.
>>
>>My problem is that I cant make the second box requery. I initialiaze the variable to 1 and the second box shows company 1's choices when the form comes up But__ when you select a second value in the insurance company dropdown the plan box doesnt filter to its choices.
>>
>>Ive tried thisform.secondbox.requery in the click event of the first box, and ive tried this.requery in the got focus and click events of the second box. Im sure this is somthing simple but its driving me nuts.
>>
>>Any ideas?
>>TIA
>>Chris