Hi every body. I got bounded form as picture below. Initially the form loads all the recod.I want add a feture to this form so that when i make 4 combo box selection it goes and load those records that matches that crieteria only . All my controles are in the main form. I am not using form and subform.I be happy if some one show me how i can switch from show all mode to filtered mode.(an example higly appretiated)Thanks


http://i5.photobucket.com/albums/y18...oboxfilter.jpg
( form pic)

Change your form recordsource to be a query with these comboboxes as criteria for each relevant field. I would suggest using the "Build" feature in the query design to get the form control reference format correct.

You will want to put a requery into your comboboxes somewhere, depending on how you want it to work... I would use AfterUpdate event, myself.