G
Guest
I have an empty form with 1 field. It is fiscal quarter. There is a fiscal
quarter table
with the fiscal quarters. I want a value list combo box that allows the
user to choose a quarter to filter a report. Here is the SQL:
SELECT tblFiscalQrt.FiscalQrtID, tblFiscalQrt.[Fiscal Quarter] FROM
tblFiscalQrt ORDER BY [Fiscal Quarter];
It is saying that the Jet engine cannot find the object forms? The value
list doesn't display. I checked the option to not store the field but save
it to use later. Do I need a control source?
What event do I use to send the value to a report so i can filter it for
that quarter?
thanks,
quarter table
with the fiscal quarters. I want a value list combo box that allows the
user to choose a quarter to filter a report. Here is the SQL:
SELECT tblFiscalQrt.FiscalQrtID, tblFiscalQrt.[Fiscal Quarter] FROM
tblFiscalQrt ORDER BY [Fiscal Quarter];
It is saying that the Jet engine cannot find the object forms? The value
list doesn't display. I checked the option to not store the field but save
it to use later. Do I need a control source?
What event do I use to send the value to a report so i can filter it for
that quarter?
thanks,