from text to combo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an unbound form where I have text boxes to enter info to pull a
report. Everything works fine. My problem is that I want to change the text
boxes to combo boxes which I did but now it does not work. The only way it
works is if I keep it as text boxes. Can someone help me with this? Thanks
 
What the use of the combo?

Check the columns of the combo, it could be, that you retreivng a different
value.
If the first column in the combo Row Source is an Id, but you need to use a
text that is located on the second column, then you need to write
Me.[ComboName].Column(1)

The column number start with 0
 
Thanks for replying.

Sorry, I don't have a lot of experience with access. Where would I enter
your code?

The combo is used as parameters to pull reports. For example if I want a
report I type in the name of the company that I want to pull the report for
and I get the report, which it wasn't to convinient because you have to type
it exactly the way the table has it which is why I changed it to combos.

I have 4 different combos, for company name, region, state and carnegie
category. Everything works fine if I leave them as text boxes but if I
change it to combo it does not work. It only works the first time using one
parameter not a combination of parameters and then I have to close the form
and open it again in order to work for one parameter only or else I get a
blank report.

The combo is pulling from a table where the company name is in the second
column. In the row source of the combo property I have this:
SELECT [Inst Base Data 1-19-06B2].Inst_Name FROM [Inst Base Data 1-19-06B2];

Ofer said:
What the use of the combo?

Check the columns of the combo, it could be, that you retreivng a different
value.
If the first column in the combo Row Source is an Id, but you need to use a
text that is located on the second column, then you need to write
Me.[ComboName].Column(1)

The column number start with 0


--
\\// Live Long and Prosper \\//
BS"D


brown_eyes said:
I have an unbound form where I have text boxes to enter info to pull a
report. Everything works fine. My problem is that I want to change the text
boxes to combo boxes which I did but now it does not work. The only way it
works is if I keep it as text boxes. Can someone help me with this? Thanks
Click to expand...
Click to expand...
 
What is the code you are using to run the report?

--
\\// Live Long and Prosper \\//
BS"D


brown_eyes said:
Thanks for replying.

Sorry, I don't have a lot of experience with access. Where would I enter
your code?

The combo is used as parameters to pull reports. For example if I want a
report I type in the name of the company that I want to pull the report for
and I get the report, which it wasn't to convinient because you have to type
it exactly the way the table has it which is why I changed it to combos.

I have 4 different combos, for company name, region, state and carnegie
category. Everything works fine if I leave them as text boxes but if I
change it to combo it does not work. It only works the first time using one
parameter not a combination of parameters and then I have to close the form
and open it again in order to work for one parameter only or else I get a
blank report.

The combo is pulling from a table where the company name is in the second
column. In the row source of the combo property I have this:
SELECT [Inst Base Data 1-19-06B2].Inst_Name FROM [Inst Base Data 1-19-06B2];

Ofer said:
What the use of the combo?

Check the columns of the combo, it could be, that you retreivng a different
value.
If the first column in the combo Row Source is an Id, but you need to use a
text that is located on the second column, then you need to write
Me.[ComboName].Column(1)

The column number start with 0


--
\\// Live Long and Prosper \\//
BS"D


brown_eyes said:
I have an unbound form where I have text boxes to enter info to pull a
report. Everything works fine. My problem is that I want to change the text
boxes to combo boxes which I did but now it does not work. The only way it
works is if I keep it as text boxes. Can someone help me with this? Thanks
Click to expand...
Click to expand...
Click to expand...
 
I don't have a code. I am not experienced with Access. Don't know much
about coding. What I did is, I pull the report by a query by form. However,
when I enter the criteria on the query it changes and adds more rows and
columns. The SQL is huge because of it. But it pulls the information that I
want. It just does not work using the combo boxes. Here is the SQL:
Its huge I hope it does not scare you!!

SELECT DISTINCTROW [Inst Base Data 1-19-06B2].IPEDS_CD, [Inst Base Data
1-19-06B2].Inst_Name, [Apps Total query].[Sum Of Num_Apps], [Apps Total
query].[Sum Of TOTAL], [sum of Num_Apps]/[sum of total] AS Yield, [Inst Base
Data 1-19-06B2].City, [Inst Base Data 1-19-06B2].State_CD,
REF_Region.Region_Desc, REF_Carn_Class.Carn_Class_Desc, [REF_Minority Serving
Institution].MinServInst_Desc, [REF_Hispanic Serving
Institution].HispServInst_Desc, [REF HBCU].HBCU_Desc, [US New Selectivity
2005 Query].[Selectivity Ranking], [US New Selectivity 2005 Query].[Inst
Type], [US New Selectivity 2005 Query].Tier, [zMCAT Contact].[MCAT Contact],
[zHealth Advisor].[Health Advisor]
FROM [zHealth Advisor] RIGHT JOIN ([zMCAT Contact] RIGHT JOIN ([US New
Selectivity 2005 Query] INNER JOIN ([REF HBCU] INNER JOIN ([REF_Minority
Serving Institution] INNER JOIN ([REF_Hispanic Serving Institution] INNER
JOIN (REF_Region INNER JOIN ([Apps Total query] INNER JOIN ([Inst Base Data
1-19-06B2] INNER JOIN REF_Carn_Class ON [Inst Base Data 1-19-06B2].Carn_CD =
REF_Carn_Class.Carn_Class_CD) ON [Apps Total query].IPEDS_CD = [Inst Base
Data 1-19-06B2].IPEDS_CD) ON REF_Region.Region_CD = [Inst Base Data
1-19-06B2].GeoReg_CD) ON [REF_Hispanic Serving Institution].HispServInst_CD =
[Inst Base Data 1-19-06B2].HispServInst_CD) ON [REF_Minority Serving
Institution].MinServInst_CD = [Inst Base Data 1-19-06B2].MinServInst_CD) ON
[REF HBCU].HBCU_cd = [Inst Base Data 1-19-06B2].HBCU_CD) ON [US New
Selectivity 2005 Query].IPEDS_CD = [Inst Base Data 1-19-06B2].IPEDS_CD) ON
[zMCAT Contact].IPEDS_CD = [Inst Base Data 1-19-06B2].IPEDS_CD) ON [zHealth
Advisor].IPEDS_CD = [Inst Base Data 1-19-06B2].IPEDS_CD
GROUP BY [Inst Base Data 1-19-06B2].IPEDS_CD, [Inst Base Data
1-19-06B2].Inst_Name, [Apps Total query].[Sum Of Num_Apps], [Apps Total
query].[Sum Of TOTAL], [Inst Base Data 1-19-06B2].City, [Inst Base Data
1-19-06B2].State_CD, REF_Region.Region_Desc, REF_Carn_Class.Carn_Class_Desc,
[REF_Minority Serving Institution].MinServInst_Desc, [REF_Hispanic Serving
Institution].HispServInst_Desc, [REF HBCU].HBCU_Desc, [US New Selectivity
2005 Query].[Selectivity Ranking], [US New Selectivity 2005 Query].[Inst
Type], [US New Selectivity 2005 Query].Tier, [zMCAT Contact].[MCAT Contact],
[zHealth Advisor].[Health Advisor]
HAVING ((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main
Menu]![filter1]) AND (([Inst Base Data 1-19-06B2].State_CD)=[Forms]![Main
Menu]![filter3]) AND ((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4])
AND ((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2])) OR
((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
(([Inst Base Data 1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2])) OR ((([Inst
Base Data 1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null)) OR ((([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter3]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter3]) Is Null)) OR
(((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter3]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND (([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter4]) Is Null)) OR ((([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter4]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter3]) Is Null) AND (([Forms]![Main
Menu]![filter4]) Is Null)) OR
(((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter3]) Is Null) AND (([Forms]![Main Menu]![filter4]) Is Null)) OR
((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
(([Inst Base Data 1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND (([Forms]![Main
Menu]![filter2]) Is Null)) OR ((([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND (([Forms]![Main
Menu]![filter1]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND (([Forms]![Main
Menu]![filter3]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
(((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND (([Forms]![Main
Menu]![filter1]) Is Null) AND (([Forms]![Main Menu]![filter3]) Is Null) AND
(([Forms]![Main Menu]![filter2]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND (([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND (([Forms]![Main
Menu]![filter4]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
((([Inst Base Data 1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
(([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter4]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
(([Forms]![Main Menu]![filter3]) Is Null) AND (([Forms]![Main
Menu]![filter4]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
((([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter3]) Is Null) AND (([Forms]![Main Menu]![filter4]) Is Null) AND
(([Forms]![Main Menu]![filter2]) Is Null))
ORDER BY [Inst Base Data 1-19-06B2].IPEDS_CD;

Ofer said:
What is the code you are using to run the report?

--
\\// Live Long and Prosper \\//
BS"D


brown_eyes said:
Thanks for replying.

Sorry, I don't have a lot of experience with access. Where would I enter
your code?

The combo is used as parameters to pull reports. For example if I want a
report I type in the name of the company that I want to pull the report for
and I get the report, which it wasn't to convinient because you have to type
it exactly the way the table has it which is why I changed it to combos.

I have 4 different combos, for company name, region, state and carnegie
category. Everything works fine if I leave them as text boxes but if I
change it to combo it does not work. It only works the first time using one
parameter not a combination of parameters and then I have to close the form
and open it again in order to work for one parameter only or else I get a
blank report.

The combo is pulling from a table where the company name is in the second
column. In the row source of the combo property I have this:
SELECT [Inst Base Data 1-19-06B2].Inst_Name FROM [Inst Base Data 1-19-06B2];

Ofer said:
What the use of the combo?

Check the columns of the combo, it could be, that you retreivng a different
value.
If the first column in the combo Row Source is an Id, but you need to use a
text that is located on the second column, then you need to write
Me.[ComboName].Column(1)

The column number start with 0


--
\\// Live Long and Prosper \\//
BS"D


:

I have an unbound form where I have text boxes to enter info to pull a
report. Everything works fine. My problem is that I want to change the text
boxes to combo boxes which I did but now it does not work. The only way it
works is if I keep it as text boxes. Can someone help me with this? Thanks
Click to expand...
Click to expand...
Click to expand...
 
If in the combo box row source you have something like

Select Id, Description From TableName

Then try and remve the id field if your filter is based on text
Select Description From TableName
=============================
Keep in mind that it's not wise to keep the text value in the main table,
you should store the Id, and that incase you change the description of one of
the records you want need to update the main table with the new value.

--
HTH, Good Luck
BS"D


brown_eyes said:
I don't have a code. I am not experienced with Access. Don't know much
about coding. What I did is, I pull the report by a query by form. However,
when I enter the criteria on the query it changes and adds more rows and
columns. The SQL is huge because of it. But it pulls the information that I
want. It just does not work using the combo boxes. Here is the SQL:
Its huge I hope it does not scare you!!

SELECT DISTINCTROW [Inst Base Data 1-19-06B2].IPEDS_CD, [Inst Base Data
1-19-06B2].Inst_Name, [Apps Total query].[Sum Of Num_Apps], [Apps Total
query].[Sum Of TOTAL], [sum of Num_Apps]/[sum of total] AS Yield, [Inst Base
Data 1-19-06B2].City, [Inst Base Data 1-19-06B2].State_CD,
REF_Region.Region_Desc, REF_Carn_Class.Carn_Class_Desc, [REF_Minority Serving
Institution].MinServInst_Desc, [REF_Hispanic Serving
Institution].HispServInst_Desc, [REF HBCU].HBCU_Desc, [US New Selectivity
2005 Query].[Selectivity Ranking], [US New Selectivity 2005 Query].[Inst
Type], [US New Selectivity 2005 Query].Tier, [zMCAT Contact].[MCAT Contact],
[zHealth Advisor].[Health Advisor]
FROM [zHealth Advisor] RIGHT JOIN ([zMCAT Contact] RIGHT JOIN ([US New
Selectivity 2005 Query] INNER JOIN ([REF HBCU] INNER JOIN ([REF_Minority
Serving Institution] INNER JOIN ([REF_Hispanic Serving Institution] INNER
JOIN (REF_Region INNER JOIN ([Apps Total query] INNER JOIN ([Inst Base Data
1-19-06B2] INNER JOIN REF_Carn_Class ON [Inst Base Data 1-19-06B2].Carn_CD =
REF_Carn_Class.Carn_Class_CD) ON [Apps Total query].IPEDS_CD = [Inst Base
Data 1-19-06B2].IPEDS_CD) ON REF_Region.Region_CD = [Inst Base Data
1-19-06B2].GeoReg_CD) ON [REF_Hispanic Serving Institution].HispServInst_CD =
[Inst Base Data 1-19-06B2].HispServInst_CD) ON [REF_Minority Serving
Institution].MinServInst_CD = [Inst Base Data 1-19-06B2].MinServInst_CD) ON
[REF HBCU].HBCU_cd = [Inst Base Data 1-19-06B2].HBCU_CD) ON [US New
Selectivity 2005 Query].IPEDS_CD = [Inst Base Data 1-19-06B2].IPEDS_CD) ON
[zMCAT Contact].IPEDS_CD = [Inst Base Data 1-19-06B2].IPEDS_CD) ON [zHealth
Advisor].IPEDS_CD = [Inst Base Data 1-19-06B2].IPEDS_CD
GROUP BY [Inst Base Data 1-19-06B2].IPEDS_CD, [Inst Base Data
1-19-06B2].Inst_Name, [Apps Total query].[Sum Of Num_Apps], [Apps Total
query].[Sum Of TOTAL], [Inst Base Data 1-19-06B2].City, [Inst Base Data
1-19-06B2].State_CD, REF_Region.Region_Desc, REF_Carn_Class.Carn_Class_Desc,
[REF_Minority Serving Institution].MinServInst_Desc, [REF_Hispanic Serving
Institution].HispServInst_Desc, [REF HBCU].HBCU_Desc, [US New Selectivity
2005 Query].[Selectivity Ranking], [US New Selectivity 2005 Query].[Inst
Type], [US New Selectivity 2005 Query].Tier, [zMCAT Contact].[MCAT Contact],
[zHealth Advisor].[Health Advisor]
HAVING ((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main
Menu]![filter1]) AND (([Inst Base Data 1-19-06B2].State_CD)=[Forms]![Main
Menu]![filter3]) AND ((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4])
AND ((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2])) OR
((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
(([Inst Base Data 1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2])) OR ((([Inst
Base Data 1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null)) OR ((([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter3]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter3]) Is Null)) OR
(((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter3]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND (([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter4]) Is Null)) OR ((([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter4]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter3]) Is Null) AND (([Forms]![Main
Menu]![filter4]) Is Null)) OR
(((REF_Carn_Class.Carn_Class_Desc)=[Forms]![Main Menu]![filter2]) AND
(([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter3]) Is Null) AND (([Forms]![Main Menu]![filter4]) Is Null)) OR
((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
(([Inst Base Data 1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND (([Forms]![Main
Menu]![filter2]) Is Null)) OR ((([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND (([Forms]![Main
Menu]![filter1]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND (([Forms]![Main
Menu]![filter3]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
(((REF_Region.Region_Desc)=[Forms]![Main Menu]![filter4]) AND (([Forms]![Main
Menu]![filter1]) Is Null) AND (([Forms]![Main Menu]![filter3]) Is Null) AND
(([Forms]![Main Menu]![filter2]) Is Null)) OR ((([Inst Base Data
1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND (([Inst Base Data
1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND (([Forms]![Main
Menu]![filter4]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
((([Inst Base Data 1-19-06B2].State_CD)=[Forms]![Main Menu]![filter3]) AND
(([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter4]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
((([Inst Base Data 1-19-06B2].Inst_Name)=[Forms]![Main Menu]![filter1]) AND
(([Forms]![Main Menu]![filter3]) Is Null) AND (([Forms]![Main
Menu]![filter4]) Is Null) AND (([Forms]![Main Menu]![filter2]) Is Null)) OR
((([Forms]![Main Menu]![filter1]) Is Null) AND (([Forms]![Main
Menu]![filter3]) Is Null) AND (([Forms]![Main Menu]![filter4]) Is Null) AND
(([Forms]![Main Menu]![filter2]) Is Null))
ORDER BY [Inst Base Data 1-19-06B2].IPEDS_CD;

Ofer said:
What is the code you are using to run the report?

--
\\// Live Long and Prosper \\//
BS"D


brown_eyes said:
Thanks for replying.

Sorry, I don't have a lot of experience with access. Where would I enter
your code?

The combo is used as parameters to pull reports. For example if I want a
report I type in the name of the company that I want to pull the report for
and I get the report, which it wasn't to convinient because you have to type
it exactly the way the table has it which is why I changed it to combos.

I have 4 different combos, for company name, region, state and carnegie
category. Everything works fine if I leave them as text boxes but if I
change it to combo it does not work. It only works the first time using one
parameter not a combination of parameters and then I have to close the form
and open it again in order to work for one parameter only or else I get a
blank report.

The combo is pulling from a table where the company name is in the second
column. In the row source of the combo property I have this:
SELECT [Inst Base Data 1-19-06B2].Inst_Name FROM [Inst Base Data 1-19-06B2];

:

What the use of the combo?

Check the columns of the combo, it could be, that you retreivng a different
value.
If the first column in the combo Row Source is an Id, but you need to use a
text that is located on the second column, then you need to write
Me.[ComboName].Column(1)

The column number start with 0


--
\\// Live Long and Prosper \\//
BS"D


:

I have an unbound form where I have text boxes to enter info to pull a
report. Everything works fine. My problem is that I want to change the text
boxes to combo boxes which I did but now it does not work. The only way it
works is if I keep it as text boxes. Can someone help me with this? Thanks
Click to expand...
Click to expand...
Click to expand...
 
Check the name of the combo boxes to make sure they have the same names as
the text boxes. The query is expecting the names to be filter1, filter2, etc.
 
They all have the same name as the query. My problem now is that it only
works once. Just to run the first report. I can run the report using the
combo boxes in any combination but only once. If I want to run another
report I have to close the form and open it again to get it to work again.
Is there something in the form's properties that can fix this problem?
Thanks for replying!!
 
I'm not sure exactly how it is set up. If the form opens a report, then you
need a requery button that closes the report and then opens it again after
you change the criteria;

Private Sub btnReQuery_Click()
DoCmd.Close acReport, "My Report"
DoCmd.OpenReport "My Report", acViewPreview
End Sub
 
Back
Top