Query Not Seeing Text on Form Field?

[Kaba]

This is really confusing me. I'm trying to reference data on an open form and use it as criteria in my query and for some reason it's not returning any records.

I have the unbounded form opened with unbound combobox (cmbOOffice) populated. However, the query is not returning any data when I know for a fact there is at least one record in the tblMainCase table where OriginOffice matches the current text displayed in the cmbOOffice field on the splash form.

SELECT tblMainCase.*, tblMainCase.OriginOffice, tblMainCase.CaseType, tblMainCase.Client
FROM tblMainCase
WHERE (((tblMainCase.OriginOffice)=[Forms]![splash]![cmbOOffice]))
ORDER BY tblMainCase.Client;

When I replace [Forms]![splash]![cmbOOffice] with "New York", it returns the record. On the other hand, even though "New York" is displayed in the cmbOOffice field, it wont. I think for some reason the query is not picking up on the data in the field. Why is this? Am I missing something?



Thanks for any help

[ssanfu]

When I replace [Forms]![splash]![cmbOOffice] with "New York", it returns the record. On the other hand, even though "New York" is displayed in the cmbOOffice field, it wont. I think for some reason the query is not picking up on the data in the field. Why is this? Am I missing something?

What is the row source of the combo box "cmbOOffice"?

If the bound column (usually the first column is the bound column and it *usually* is the primary key, a long integer) is not a text field, then it would make sense that no records are returned.

This would be the first thing I would check since the query returned a record when a text string was substituted.

[Kaba]

RowSource = SELECT tblMainCase.Matter, tblMainCase.OriginOffice FROM tblMainCase ORDER BY tblMainCase.OriginOffice;

Bound Column = 1

Again, the ComboBox is displayed just fine with the expected data. It's the query that references it that somehow don't see the displayed text/data.

Thanks for the help. Much appreciated.

[ssanfu]

RowSource = SELECT tblMainCase.Matter, tblMainCase.OriginOffice FROM tblMainCase ORDER BY tblMainCase.OriginOffice;

Bound Column = 1

Again, the ComboBox is displayed just fine with the expected data. It's the query that references it that somehow don't see the displayed text/data.

Thanks for the help. Much appreciated.

If "OriginOffice" is the field that contains "New York", then try:

SELECT tblMainCase.*, tblMainCase.OriginOffice, tblMainCase.CaseType, tblMainCase.Client
FROM tblMainCase
WHERE tblMainCase.OriginOffice = [Forms]![splash]![cmbOOffice].Column(1)
ORDER BY tblMainCase.Client;

I am curious as to why you have "OriginOffice", "CaseType" & "Client" fields in the query twice. When you have "SELECT * FROM....", "SELECT *" means to include all fields. The "*" is a wildcard in Jet SQL.