Relational Combo Boxes
DLookup
AfterUpdate

I probably was.t clear on what I'm asking.  Instead of scrolling through each record and finding the one I need, I'd like a combo box to provided a drop down list of all my items where I can select the one I need based on an item no.  When I pick the item number  from the list, all the fields related to the item number (description of item, unit, unit price, etc) will display up on my form.

All those links Kevin provided give you Lego pieces to achieve what you ask.
What parts aren't you able to do given the videos?

List Box Filter works with combo boxes too

Alex. I went through the sources he provided.  The fields are already on the form with all the column information of  a specific record.  I just want. to build a combo box that will select the item from a drop down list.  The combo box doesn't seem to be bound to all the columns. They are not updating when I select the item. I'm on Expert Level 4 so maybe it will be explained in a future course. I went back to previous courses but couldn't find a solution.

Robert when I first started out, and even now sometimes, it helped me to talk out loud what i wanted.
If you don't want people thinking your crazy even write out the steps.
Like this:
After I pick an "ItemNo" from the combo box (Afterupdate that Kevin gave you above) I want Access to lookup the ID of that ItemNo  ( DLookup ) from the PartsT table (Relational Combo) and find the ItemDescription, UnitCost, PlanQuantity and put it into my order form.

The AfterUpdate is an event that happens when you choose the item and you write it out in the Code Builder.
In order to fill it in you would have to type in the values you just looked up.
    ItemDescription = Description      (from the PartsT )
    UnitCost = Cost
    PlanQuantity  = Qty

You have to set the values that you looked up into the text boxes for your form.
Over simplified but that will give you an idea how to go back and re-watch the videos paying attention how to apply it to your situation.

I see you are a LC member and that is fantastic (Keep that going and keep on trucking).
One thing you might want to consider - and I highly recommend doing so - is getting at least the Silver TechHelp membership (Gold is even better because you have access to download sample DBs and Code).

It's not that much more than what you are paying now, but you get so much out of the extended cuts that isn't covered in the Free videos.  Check it out here:  Memberships

Robert, what you're looking for is specifically covered in either the Extended Cut for the Invoicing video, or Access Expert 22, Lesson 3, which you already have. In both cases, you pick a product from a combo box and it adds all the details to the order. Same thing you're trying to do.