Query by Form

[PJFry]

I am attempting to use the QBF functionality in Access. I have a form,
fDrill with a combo box, cboCustName. I want to use the cboCustName in my
query, qDrill.

In qDrill I have the condition on CustName set to
=[Forms]![fDrill]![cboCustName] and the query returns no records. If I type
in the value from the combo box, in this case "Sharp" the query returns the
records.

What am I missing?

I am running Access 2007 on XP Pro, SP2.

Thanks!
PJ

 

[Ivan Grozney]

Is the value of "sharp" the bound column in your combo box?

 

[PJFry]

That is what it was. I went back and saw that my bound to column was 0
instead of 1.

Thanks!

PJ

Is the value of "sharp" the bound column in your combo box?

I am attempting to use the QBF functionality in Access. I have a form,
fDrill with a combo box, cboCustName. I want to use the cboCustName in my
query, qDrill.

In qDrill I have the condition on CustName set to
=[Forms]![fDrill]![cboCustName] and the query returns no records. If I type
in the value from the combo box, in this case "Sharp" the query returns the
records.

What am I missing?

I am running Access 2007 on XP Pro, SP2.

Thanks!
PJ