Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / January 2007

Tip: Looking for answers? Try searching our database.

combo box value list of fiscal quarter Select Query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
FilemakerPro_Developer - 30 Jan 2007 21:54 GMT
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,

Signature

Janis

FilemakerPro_Developer - 30 Jan 2007 22:01 GMT
Oh sorry, the problem was with my computer they changed the password in
Windoze.
Signature

Janis

> I have an empty form with 1 field.  It is fiscal quarter.  There is a fiscal
> quarter table
[quoted text clipped - 12 lines]
>
> thanks,
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.