REPORT not displaying

[ghostman via AccessMonster.com]

I having problem with my report. I have pop up form with a combo box where
you can select the languages. (English, Arabic, Hindi, etc..) based on my
Instructor table and a command button to trigger the report. The problem is
there is no report displayed after selecting the language and clicking on the
command button while if you do it in the query itself, it works fine. (a
parameter value pops up and i type the language). it also works without using
the pop up form, but i want it to be complicated lol!

i don't know what i am missing...

here are some data:

Row source of my combo box [SelectLanguage]:

SELECT [Instructors].[InstructorID], [Instructors].[Language] FROM
Instructors ORDER BY [Language];


Command Button [cmdPreview] onClick Event procedure:

Private Sub cmdPreview_Click()
Me.Visible = False
End Sub

and here's the SQL of the query based on the Instructor table:

SELECT Instructors.InstructorID, Instructors.FirstName, Instructors.
MiddleName, Instructors.LastName, Instructors.Initials, Instructors.
JobPosition, Instructors.Language, Instructors.TimeOfAvailabilityF,
Instructors.TimeOfAvailabilityT, Instructors.VacationScheduleF
FROM Instructors
WHERE (((Instructors.Language)=[forms]![ParamForm]![SelectLanguage]));

 

[Piet Linden]

I having problem with my report. I have pop up form with a combo box where
you can select the languages. (English, Arabic, Hindi, etc..) based on my
Instructor table and a command button to trigger the report. The problem is
there is no report displayed after selecting the language and clicking onthe
command button while if you do it in the query itself, it works fine. (a
parameter value pops up and i type the language). it also works without using
the pop up form, but i want it to be complicated lol!

i don't know what i am missing...

here are some data:

Row source of my combo box [SelectLanguage]:

SELECT [Instructors].[InstructorID], [Instructors].[Language] FROM
Instructors ORDER BY [Language];

Command Button [cmdPreview] onClick Event procedure:

Private Sub cmdPreview_Click()
Me.Visible = False
End Sub

and here's the SQL of the query based on the Instructor table:

SELECT Instructors.InstructorID, Instructors.FirstName, Instructors.
MiddleName, Instructors.LastName, Instructors.Initials, Instructors.
JobPosition, Instructors.Language, Instructors.TimeOfAvailabilityF,
Instructors.TimeOfAvailabilityT, Instructors.VacationScheduleF
FROM Instructors
WHERE (((Instructors.Language)=[forms]![ParamForm]![SelectLanguage]));

Really simple. The value getting passed is the value in the first
column of the combobox, which is InstructorID, and not Language, which
is what I think you intend. If you want to capture the value in the
next column, you need to use:

WHERE (((Instructors.Language)=[forms]![ParamForm]!
[SelectLanguage].Column(1)));

 

[ghostman via AccessMonster.com]

thanks for the response

i tried it but an error occurs saying undefined function '[forms]![ParamForm]!
[SelectLanguage].Column' in expression.

I having problem with my report. I have pop up form with a combo box where
you can select the languages. (English, Arabic, Hindi, etc..) based on my

[quoted text clipped - 30 lines]
Really simple. The value getting passed is the value in the first
column of the combobox, which is InstructorID, and not Language, which
is what I think you intend. If you want to capture the value in the
next column, you need to use:

WHERE (((Instructors.Language)=[forms]![ParamForm]!
[SelectLanguage].Column(1)));

 

[ghostman via AccessMonster.com]

ADDITIONAL INFO:

here is the row source of the SelectLanguage combo box:

SELECT [Instructors].[InstructorID], [Instructors].[Language] FROM
Instructors ORDER BY [Language];

thanks for the response

i tried it but an error occurs saying undefined function '[forms]![ParamForm]!
[SelectLanguage].Column' in expression.

On Aug 16, 12:37 am, "ghostman via AccessMonster.com" <u51724@uwe>
wrote:

[quoted text clipped - 11 lines]

WHERE (((Instructors.Language)=[forms]![ParamForm]!
[SelectLanguage].Column(1)));

 

[ghostman via AccessMonster.com]

oppsss...i got it! i set the bound column to 2 instead of 1.
Thank you very much...

I having problem with my report. I have pop up form with a combo box where
you can select the languages. (English, Arabic, Hindi, etc..) based on my

[quoted text clipped - 30 lines]
Really simple. The value getting passed is the value in the first
column of the combobox, which is InstructorID, and not Language, which
is what I think you intend. If you want to capture the value in the
next column, you need to use:

WHERE (((Instructors.Language)=[forms]![ParamForm]!
[SelectLanguage].Column(1)));