Filtering a form

[mlopes1]

I know this is a simple question, but I am new to this so please bare patience.

I have a main form where users select a company from a combo box and then fill in the product they purchased, quantity, price, etc.

I want another combo box at the top of the form that would allow the user to choose from a list of companies, and then it would filter the forms to show only those records.

How do I do this? And if it involves a combo box, I have also run into the following problem:

My second question is related. Currently, the combo box on the record where the user enters the sales information, saves the company name as its index. For example, Company A ='s 1, Company B ='s 2, etc. This is how I had designed it, but now, if I create a combo box that allows the user to select a company who has bought products, it lists the index, not the name, since that is what is stored in the Selected_Company field. any and all suggestions are much appreciated. Thank you!

 

[Trevor Howard]

Hi,
as to your question about showing your data in a combo, see this posting by Brad, via TABLES under "Help! I need the table to display information from a form..


" he said "If you look and the properties of the combo box, check the following:

Column Count - Should be actual number of columns in your list
Bound Column - Normally 1 (ie: first column - key number etc)
Column Widths - Set it as: 0;2;2; etc.

The main importance is on the first width digit. (ie: 0 - zero ) The other figures you will have to set to suit.

Thus the first column is hidden, but stores the correct result in the table and displays the more relevant column information."

Good luck
Trevor