interactive combo box on continuous form

[diversoln]

I have a continuous form that displays a filtered table. I use a combo box on a previous form to select the desired part number and the continuous form is based on a select query using the result of the combo box. It works great.

What I'd really like to do is have the combo box right on the continous form (probably in the header) so that I can change the part number used as the filter & have the contents of the form update when the new number is selected.

Any ideas ? Thanks !

 

[diversoln]

I'm still having a bit of difficulty with this. First, I'm unclear why you set the combo box null. And when do you actually requiry the table ?

 

[diversoln]

Also, I'm not sure what happened to your reply to my message. I read it & attempted to apply it after reviewing the build criteria method help......

 

[R. Hicks]

I am sorry for removing the reply ......

I re-read your question and my reply would not be correct for a "continuous form". This is the reason I removed it. I had hoped I caught my mistake before you attempted to use this.

Sorry for any trouble I may have created.

RDH

 

[diversoln]

It would seem like I could set the "on change" property for the form to run a requery event but this doesn't get me there. Any ideas why that would fall short? I'mkinda new at this.