Oxeagle
20th Dec 2006, 12:45
Afternoon chaps,
I have a question regarding designing a form in Microsoft Access 2003. Basically, what i'm trying to do is this:
I have a database with a table of flight information, and a form to display it on. I want to use a date/time picker on the form (or just a text box for the user to type the date into if all else fails) to select a date from a calender view, and information for flights on this date will be displayed below in the same form. I have set this up, but I can't work out how to configure the date/time picker and/or the filter options for the 'Date' field in the flight table so that it only displays the flight information of flights on the same date as selected by the date/time picker. :confused:
Anyone have any ideas?
Ox
I have a question regarding designing a form in Microsoft Access 2003. Basically, what i'm trying to do is this:
I have a database with a table of flight information, and a form to display it on. I want to use a date/time picker on the form (or just a text box for the user to type the date into if all else fails) to select a date from a calender view, and information for flights on this date will be displayed below in the same form. I have set this up, but I can't work out how to configure the date/time picker and/or the filter options for the 'Date' field in the flight table so that it only displays the flight information of flights on the same date as selected by the date/time picker. :confused:
Anyone have any ideas?
Ox