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 / May 2008

Tip: Looking for answers? Try searching our database.

Combo box / Query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ghagg - 27 May 2008 17:48 GMT
Thank you Wayne-I-M for responding

FYI: I'm using Access 2007, and the combo boxes are unbound.  The fields i'm
using are not primary fields, and i use the Distinct key word for populating
the combo boxes, which worked in the cascading listbox example.

OK, Consider this, i have a table with over 100K records, about 50 fields.
The class field has 210 items that repeat through out the records in this
table.  I want to chose this class field as an example, then select one item
in the drop-down combo box, and filter all records based on the combo box
selection.  I also have 3 cascading combo boxes.

I hope the combo box works like the list box,  As i previously mentioned, i
have been able to get the 3 cascading list boxes to work with 3 different
queries.  The Second list box query selects from the first list box query...

I think the problem i'm having is passing the value from the combo box
selection to the query.

Thanks for your help

Best regards,

Glenn (ghagg)
Wayne-I-M - 27 May 2008 20:01 GMT
Hi

You should try to responpond to the same threat so that there is a contious
line of posts that people can read and see any problems/questions.

I still think the answer lays in simply creating a query then filtering it
on your combo selection - this can be the primary field or the distinct
text/number/forumla/etc

Can I suggest something

Make a copy of your database.

Open the form with the 3 combos on it
Delete the source from the 2nd 2 in the casscade
(if you need to) use the wizard to creat 2 more querrys (click the build
option on the property's data column).  Which you are still in the design
view of the querry use the build option on the criteria row (point to the
previous combo in the casscade - to the bound column in the combo)

Your 3 combos will casscade as you need.

Signature

Wayne
Manchester, England.

> Thank you Wayne-I-M for responding
>
[quoted text clipped - 20 lines]
>
> Glenn (ghagg)
 
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.