query by form problem

[detgharris]

Ok, I have a main form that has four unbound combo boxes on it. The first is for date with a pop up calendar, the last three are other controls with dropdown items. This is linked to a query where I do the query by form. Also on the form I have a subform that shows the results of the query by form. I am trying to get the subform to filter after update of any of the unbound boxes from the main form. I am able to get a pop up subform if I put a command button to openform, however, I just want the information to update in the subform that I have created. Any suggestions??

 

[Darrylles]

det,

Doesn't the <On Change> event work on these combo boxes?

ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.