combo box value list of fiscal quarter Select Query

  • Thread starter FilemakerPro_Developer
  • Start date
F

FilemakerPro_Developer

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,
 
F

FilemakerPro_Developer

Oh sorry, the problem was with my computer they changed the password in
Windoze.
 
Top