Table Results Issue and Ordering

[AcmeGearSteve]

Hey there, I've got two questions...



(I asked this before and got great help, but I think I just need a more basic answer)

First off, I'm relatively new to Access and am learning it to build a database for my company, starting with an Inventory database. I'm using Access 2007 and have little to no experience with VBA; the macros I've gotten the hang of though.

First question: I have a "Find Part" Form. In this form, I have:

• Company Name (Drop down box), "Find Record" button
• Part Number (Drop down box)
• Quantity (Drop down box)
• Location (Drop down box)

Now, the issue I'm having is with the button. It works with the Company Name, but the issue is, regardless of the company selected, it displays ALL the companies in my "Customer" Table. Is there ANY way to just display the results of the Company selected?

Secondly, in my drop down box for Companies, is there anyway to list them alphabetically? I have to keep adding company names as I get them, but would prefer if they were listed alphabetically rather then as the latest entries at the bottom.

Thanks in advance,
AcmeGear Steve

[pbaldy]

What's the code behind the Find Record button? Somehow you need to add a restriction on company.

For the second, instead of just listing the table in the row source, click on the ellipsis to the right and build a query, including a sort on that field.