How to create form which will collect parameters

[Kivan]

Hi,

I have table with customers. This table has few columns, for example type (customer type), spendings etc.. Now I have a query which choose customers by few paramaters, for example type (so you need to write customer type). Now I want to create a form which will collect those parameters, and also some fields type in this form should be combo boxes. What's more data to those combo boxes should be taken from the tables (for example, from a table with customer types). How to create such kind of form?

[huongdl1987]

It would be easier if you would attach your database-- then i can provide better direction.

Basically, if you select the table, and then on the custom ribbon select form. ACCESS would automatically create a form based on this table.

Then, for the combobox, for example, customer type, you can select Row Source; that will bring you up to a query. Select the "total" and choose group by.

Good luck!

Meo