Passing parameter between forms

[jamedadi]

Hi

I have create a Table named as "Student", with 3 fields: ID, stdName, and stdField.

I also have created a Query named as "stdQuery". This query return the stdField of a given stdName . Using the SQL language, it can be written as:
Select stdField from Student where stdName = 'John' (for example)

In the following, I have created a Form named as "studentField". To create this form, I have used "Form wizard" to map the form to "stdQuery". Up to now, everything is fine.



In the following, I have defined a second form, namely "studentName". This form contains a comboBox which presents the names of the students. I want that when choosing the name of a student in the comboBox, its field is presented in "studentField". Therefore, I have written the following code in the on_click function of the comboBox of "studentName":

DoCmd.OpenForm "studentField", , , "stdName = " & combo0.selText

But when selecting a name in "studentName", it asks for a stdName as if I don't pass it to "studentField".

Cloud anyone please help me about the problem?

[pbaldy]

If the form is based on that query, it doesn't have that field in the SELECT clause, so not available for the wherecondition.

[Missinglinq]

Additionally, ff the student name the Bound Field of the combo0 Combobox? If not, which column does it appear in, keeping in mind that going from left to right, the 1st column is Column(0), the 2nd column is Column(1), etc.

selText is the wrong property to be using here. If the student name is the Bound Field, you'd simply use

Me.combo0.Value

or, even simpler

Me.combo0

From the name, I assume that stdName is just that, a name, i.e. Text. If that is correct, the Where part of the command would be

"stdName = '" & Me.combo0 & "'"

Linq ;0)>

[jamedadi]

Hi
Thank you for your reply. I have done all of your mentioned notes. Especially:

Me.combo0.Value
"stdName = '" & Me.combo0 & "'"

But it didn't work again!!!

[jamedadi]

I even tested the following:
DoCmd.OpenForm "studentField", , , "stdName= 'John'"

But it does not work again !!!!

[June7]

Show the RowSource of the combobox. Does it include the ID field? Is ID the BoundColumn?

If you want to provide db for analysis, follow instructions at bottom of my post.