MS Access Form Filter using Combo Box

I'm just trying to filter out the data in the form field which is pulling from a table.  I have a combo box set up but I can't get it to filter the data out.

First, make sure the combo box does not have a control source.  Second, make sure the bound column of the combo box is the one you want to filter on.  Third, reference the combobox in a WHERE clause of the form's underlying record source.  Fourth, requery the form in the afterupdate event of the combobox.

Wow, you lost me.
Okay, The combo box does not have a control source.  The bound column is "2" and it is the second field on the form.  Not sure if that has anything to do with it.  I'm not sure what you talking about on the WHERE clause of the form's underlying record source.  Then what do I put in the afterupdate?

>The bound column is "2" and it is the second field on the form.  

Position on the form makes no difference.  Bound column 2 means that the combo box takes its value from the third column of its row source.  That column should contain the value you want to filter on.

Go to the data tab on the form's property sheet.  What is the record source?

In the afterupdate event of the combobox, include this:

me.Requery
 

I reset the bound column back to 1 so it will look at the 2nd field in the form.  I went to the form data and the record source is "Carrier Tool Location" which is the name of the Table the form is pulling from.  I also added the   me.Requery  to the afterupdate event of the combobox.

>I reset the bound column back to 1 so it will look at the 2nd field in the form.

Field position in the form is NOT important.  The combobox has a rowsource property.  Set the bound column to the appropriate column in the rowsource.  Relative to zero, as you already know.

>I went to the form data and the record source is "Carrier Tool Location"

Now you need to apply your combobox selection to limit the record source.  There are two approaches.  The first uses the filter property of the form.  That's the easiest, but I stay away from that approach because some usersl figure out how to toggle on/off the filter and mess things up.  

The second approach is to put a condition on your record source.  Change the record source to this:

Select * from [Carrier Tool Location] where [Carrier Number]=Forms!YOURFORMNAME!YOURCOMBOXNAME

If you'd prefer to see all the rows when the combo box is not selected, then add this expression to the end of the record source:

or Forms!YOURFORMNAME!YOURCOMBOBOXNAME is null

I tried the second approch and I got an error message
Error Message:
Syntax error (missing operator) in query expression '[Carrier Number]=Forms!Carrier Tool Location!CarrierFilter'.

I have in the record source:
Select * from [Carrier Tool Location] where [Carrier Number]=Forms!Carrier Tool Location!CarrierFilter

Use square brackets around your form name that contains spaces:

Select * from [Carrier Tool Location] where [Carrier Number]=Forms![Carrier Tool Location]!CarrierFilter

I am assuming [Carrier Number] is indeed a numeric datatype.

Also, best practice is to avoid spaces in all of your access names:  tables, forms, queries, controls, etc.  Following that practice makes Access a lot more friendly.  

Okay, that seemed to work because I can open my form now.  Before I couldn't open it.  Now I'm getting "Microsoft Office Access can't find the macro 'me.'  This is in that combo box when I scroll down and select the carrier number I want to view.  After I select it, I get this error and it doesn't filter.  
Also, the carrier number is not a numeric datatype, it has to be text because some of the numbers start with a 0-

If filters now but it filters everything out including my selection on the combo box?