By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,780 Members | 1,549 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,780 IT Pros & Developers. It's quick & easy.

Dispaly values in subform based on multiple combo boxes

P: 1

I am new to MS Access and stuck in a problem from few days.

My Question: I have 3 combo box (Submitter, date from and date to) on my form and i want that when i select values from each of these combo boxes, a subform will display all the matching rows based on it, display rows based on selected submitter and the between the dates chosen in 2nd and 3rd combo boxes. All the values are coming from same table. 'date to' and 'date from' is also from same column.

Right now, my subform is displaying rows but not based on all combo box's selection, when i select submitter, it display only for that submitter,not for the chosen dates and vise verse.

2nd, my form is not displaying values between the chosen dates.

Please help me solve my problem. Thanks :)
Dec 19 '10 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,470
Check out Cascaded Form Filtering. It should have examples of all you need there.
Dec 19 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.