Query criteria from a form

[chancer1967]

This one is driving me spare...


I have a query the shows customer balances in detail. the first field is customer name, and I want to have a criteria on that field that comes from a form.

I have created a form, called Customer Detail that has just a single combo box from the customer details table. the combo box is working fine and is called CustomerCombo

In the query I have added the criteria [Forms]![Customer Detail]![CustomerCombo] to the customer field

but every time I open the query it asks me to input Forms!Customer Detail!CustomerCombo as if it is a user entered parameter

clearly a simple and basic error somewhere. but where???

 

[neileg]

Have you spelled it correctly (that space in the middle of your form name is a problem waiting to happen)?

The other thing to be aware of is that the form must be open when you run the query. Access can't refer to an object that isn't open.

 

[chancer1967]

The form is open and I used 'build' to ensure I got the spelling right

 

[Rich]

which is the bound column and what does it display?

 

[chancer1967]

Aha! It was unbound. doh!