Can't pull all the

I have a form to search the studentId and then display in listbox or combobox
for order# and orderDate but it only display one record. I would like it to
display all the order# by the student i type in search unbound box.

Anyone spot the mistake?

Column count: 2
Column width: 2";2"
Bound Column: 1
Row sources is from the query below
SELECT Table.[Order#], Table.OrderDate
FROM Table
WHERE
((([Table].[Student#])=Me.Form.StudentInfo.Form.CustInfoStuNo.Column(1) ));

This is what is doing it. You are limiting your row source to a specific a
specific record:

WHERE
((([Table].[Student#])=Me.Form.StudentInfo.Form.CustInfoStuNo.Column(1) ));

"hoachen" wrote in message
...
I have a form to search the studentId and then display in listbox or
combobox
for order# and orderDate but it only display one record. I would like it
to
display all the order# by the student i type in search unbound box.

Anyone spot the mistake?

Column count: 2
Column width: 2";2"
Bound Column: 1
Row sources is from the query below
SELECT Table.[Order#], Table.OrderDate
FROM Table
WHERE
((([Table].[Student#])=Me.Form.StudentInfo.Form.CustInfoStuNo.Column(1) ));

I don't understand why you said that. I put in a unbound text search (custID)
and the result should show me the CustID it enter and display only this
custID order# and orderDate which will have multiple order#. You said limited
the row source. How can i change it to what it have?

"Klatuu" wrote:

This is what is doing it. You are limiting your row source to a specific a
specific record:

WHERE
((([Table].[Student#])=Me.Form.StudentInfo.Form.CustInfoStuNo.Column(1) ));

"hoachen" wrote in message
...
I have a form to search the studentId and then display in listbox or
combobox
for order# and orderDate but it only display one record. I would like it
to
display all the order# by the student i type in search unbound box.

Anyone spot the mistake?

Column count: 2
Column width: 2";2"
Bound Column: 1
Row sources is from the query below
SELECT Table.[Order#], Table.OrderDate
FROM Table
WHERE
((([Table].[Student#])=Me.Form.StudentInfo.Form.CustInfoStuNo.Column(1) ));


.