Form creation with 6 comboboxes

[Shiva]

Hi,
I have a huge access database table 'ITEMS' containing 20 columns and
15000rows. I want to create a form to select criteria. I need to add 6 combo
boxes from 6 columns in 'ITEMS' table, as per the selection criteria in
combo boxes, the rows should be selected and displayed in a seperate table. I
need three buttons as 'Select' to start selecting values in combo box and
another is 'RUN' to execute and extract data into seperate table. Another one
button is 'EXIT'
Can anyone help me to create a form with above requirement please?

 

[John W. Vinson/MVP]

Hi,
I have a huge access database table 'ITEMS' containing 20 columns and
15000rows. I want to create a form to select criteria. I need to add 6 combo
boxes from 6 columns in 'ITEMS' table, as per the selection criteria in
combo boxes, the rows should be selected and displayed in a seperate table. I
need three buttons as 'Select' to start selecting values in combo box and
another is 'RUN' to execute and extract data into seperate table. Another one
button is 'EXIT'
Can anyone help me to create a form with above requirement please?

First off... do you REALLY need to extract the data into a separate
table? In general you do *not* need to create a new table, and doing
so will bloat your database. Just base a second form on a Query
referencing the first form in its criteria, using

=[Forms]![NameOfForm]![NameOfCombo]

on the criteria line, and have your RUN button open this form (the
command button tool on the toolbox will give you this option if you
select the magic wand icon).

 

[Shiva]

Thanks John,
First of all, I don't know creating first form with six combo boxes to
query. Please help me in this regard. The result can be either displayed in a
spread sheet or in another data table. Please help me to create the initial
steps to create form with combo boxes.

Hi,
I have a huge access database table 'ITEMS' containing 20 columns and
15000rows. I want to create a form to select criteria. I need to add 6 combo
boxes from 6 columns in 'ITEMS' table, as per the selection criteria in
combo boxes, the rows should be selected and displayed in a seperate table. I
need three buttons as 'Select' to start selecting values in combo box and
another is 'RUN' to execute and extract data into seperate table. Another one
button is 'EXIT'
Can anyone help me to create a form with above requirement please?

First off... do you REALLY need to extract the data into a separate
table? In general you do *not* need to create a new table, and doing
so will bloat your database. Just base a second form on a Query
referencing the first form in its criteria, using

=[Forms]![NameOfForm]![NameOfCombo]

on the criteria line, and have your RUN button open this form (the
command button tool on the toolbox will give you this option if you
select the magic wand icon).

 

[John W. Vinson/MVP]

Thanks John,
First of all, I don't know creating first form with six combo boxes to
query. Please help me in this regard. The result can be either displayed in a
spread sheet or in another data table. Please help me to create the initial
steps to create form with combo boxes.

Open the Forms window. Select the New Form button. Don't select any
table or query - this is an unbound form, and doesn't have any table.

Then use the Toolbox combo box tool to add your six combo boxes. Each
should use its own appropriate table or query as its rowsource; the
bound column would be whichever field you want to use as the
criterion. The combos will have nothing in their Control Source
property (the wizard will give you the option to "save this value to a
field" or "keep it for other use", choose the latter).