Simple Form - Please help?

[Johnrg]

Guys,
I am new to this type of form can you please help.

I have a simple form thats data source is a query. This query looks at historical customer order details. There are 19706 records when the query runs.

I have created a new form with an unbound combo that row source is the customer names table and I can select a customer from this table in the combo box OK.

However, I want the records to filter down from 19706 to just show those that relate to the customer I select and I then want a command button to run a report showing this selection.

I am stuck on how to do the following:

(1) The data in my combobox from the customers table is not alphabetical - how can I sort this?

(2) How do I create the filter on the records from the combobox selection?

(3) How do I run a report from the filitered combobox selection.

Thanks guys

JohnG

 

[John Big Booty]

Guys,
.....

I am stuck on how to do the following:

(1) The data in my combobox from the customers table is not alphabetical - how can I sort this?

...

Whilst the form is in design view click on the combo, Go to the Data tab, now click in the Row Source row, a small button will appear at the right hand end of the row with three small dots on it, click this button. Now just set the sort order for customer name as Ascending.

...

(2) How do I create the filter on the records from the combobox selection?

...

This article should explain how to do this.

...


(3) How do I run a report from the filitered combobox selection.

..and another link. Remember Google is you friend when it comes to hunting down solutions to most of your problems