Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 3rd, 2006, 12:04 PM
Registered User
 
Join Date: Aug 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Filter records using a combo box

Can someone please give me some direction. Simply put, I want to use a combo box to filter out records in a table. I have no idea how yo do this.

Thanks
JC

 
Old August 3rd, 2006, 12:10 PM
Registered User
 
Join Date: May 2004
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Not sure of what you're trying to do exactly, but you can filter records in a combo-box using a query as the record source.

Mel

Mel Cape
 
Old August 3rd, 2006, 12:43 PM
Registered User
 
Join Date: Aug 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Mel,

Ideally, I would like to use a combo box as a filter by selection would be used. I have a form with employees and overtime dates. At any one time I would like to select, from a combo box, a given date and see all the people who worked on that date. Then other times select, from a different combo box, a particular employee and see when they have worked an overtime shift. Or possibly a date then an employee or vice versa.

Does that help?

JC






Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo box to display items from parent combo box Gini Visual Studio 2008 0 June 18th, 2008 12:30 AM
Combo box choice creating filtered combo box stevensj5 Access 11 September 13th, 2007 11:33 AM
How to apply filter to shrink combo box records beetle_jaipur Access 3 July 28th, 2007 01:58 AM
Filter by Combo Boxes Corey Access VBA 5 June 1st, 2006 07:33 PM
Combo box that links records from two tables... takawera Access VBA 1 October 14th, 2003 05:39 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.