S
scubadiver
I have two combo boxes in a form. The first combo box is "txtdatefrm" and the
source of the table is a query which contains a list of dates. The second
combobox is "txtdateto".
What I would like to do is create the list for the 2nd combo box only for
those dates greater than the date that has been chosen in the first box.
This is what I have.
SELECT [dateID].[WeekID] FROM date WHERE (([dateID].[WeekID]>[report
options].[txtdatefrm]));
It says there is a syntax error in the "FROM" clause. Not too sure why.
cheers
source of the table is a query which contains a list of dates. The second
combobox is "txtdateto".
What I would like to do is create the list for the 2nd combo box only for
those dates greater than the date that has been chosen in the first box.
This is what I have.
SELECT [dateID].[WeekID] FROM date WHERE (([dateID].[WeekID]>[report
options].[txtdatefrm]));
It says there is a syntax error in the "FROM" clause. Not too sure why.
cheers