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

Filter SubForm using command button on main form.

P: 52
Hi everyone! I’m not sure how to even begin. I have a form and a subform and they are not linked. I would like to have a button on the form that would only change the data in the subform, specifically the date field. I have a field called StartDate and I would like to show only those records in the subform that equal today’s date. Where do I begin, and what is the best method. Thanks everyone…
Dec 11 '07 #1
Share this Question
Share on Google+
2 Replies


100+
P: 167
Hi everyone! I’m not sure how to even begin. I have a form and a subform and they are not linked. I would like to have a button on the form that would only change the data in the subform, specifically the date field. I have a field called StartDate and I would like to show only those records in the subform that equal today’s date. Where do I begin, and what is the best method. Thanks everyone…

Hi D.

In underlying query (in design view) of your subform put: =Now() in criteria row to filter records for today only.

If you want to show records that have date equal to StartDate on your MainForm, then you should put in Criteria row expression like:
=Forms!MainForm.StartDate

best, h.
Dec 11 '07 #2

P: 52
Thanks. How would i use a command button to change the parameter on the field in the query?
Dec 11 '07 #3

Post your reply

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