Query by Form

  • Thread starter Thread starter PJFry
  • Start date Start date
P

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
 
That is what it was. I went back and saw that my bound to column was 0
instead of 1.

Thanks!

PJ

Ivan Grozney said:
Is the value of "sharp" the bound column in your combo box?

PJFry said:
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
Click to expand...
Click to expand...
 
Back
Top