I have one table called "Response" which has contains a date field. I have a form called "Response View" which is used to view the data in this table. I have another form called "Menu" which has 12 command buttons (JAN-DEC). I want to be able to click on the (eg) JAN command button and that bring up the "Response View" form but only display the records where the date equals 01/01/01-31/01/01 (only contains and will ever only contain 2001 data).
What is the easiest way to do this?
Many thanks.
What is the easiest way to do this?
Many thanks.