PC Review


Reply
Thread Tools Rate Thread

How do I use Combo Boxes to filter information in Access?

 
 
=?Utf-8?B?SlBsYXQ=?=
Guest
Posts: n/a
 
      3rd May 2006
Is there a simple way to do this or do i need to write lines of code for
access to perform this operation? If so where can i find what code to use it
has been a while since i have used Visual Basic.
 
Reply With Quote
 
 
 
 
=?Utf-8?B?YXhlbGNvcmU=?=
Guest
Posts: n/a
 
      3rd May 2006


"JPlat" wrote:

> Is there a simple way to do this or do i need to write lines of code for
> access to perform this operation? If so where can i find what code to use it
> has been a while since i have used Visual Basic.


If you are wanting to quickly jump to a record based off of your criteria:
Just add a combo box to your form (a wizard should pop up when you add the
combo box, if it doesn't click on the "controls wizard button on your
toolbar, should be second button) then click on find record in my form based
on the value i type in the text box. Then follow the wizard.

If you are wanting to see all records that match your criteria:
then choose Records|Filter|Advanced Filter from the menu bar and then you
can enter your criteria. Choose Filter|Apply filter from the menu bar. This
will show you all records that apply. To export this list to word or excel
click file export and then choose the appropriate format and location.


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2007 - Using Cascading Combo Boxes to Filter a Query skiptotheend General Software 0 12th Oct 2009 02:12 PM
Filter Combo Box on multiple other combo boxes =?Utf-8?B?ZHVrZXR0ZXI=?= Microsoft Access 1 8th Mar 2007 08:10 PM
Filter combo box from multiple combo boxes =?Utf-8?B?Y29hY2hqZWZmZXJ5?= Microsoft Access Forms 3 10th Nov 2005 12:41 AM
Filter from two combo boxes Gary Hull Microsoft Access Form Coding 6 23rd Feb 2004 08:11 AM
Multiple Combo Boxes used to filter information displayed on form =?Utf-8?B?RFc=?= Microsoft Access Form Coding 2 13th Nov 2003 09:40 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:48 PM.