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

[Guest]

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.

 

[Guest]

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.