Query ?

[T588]

This should be obvious. I’m overlooking something?

The database I submitted only has the following:
1. Table: “Salespersons”
2. Form: “SelectSalespersons”
3. Query: “SelectSalespersonsQuery”

Building off information I found of this site I should be able to open the form (item 2 above) and select a salesperson from the drop-down combo box and without closing the form, open the query and it should display info based on the value in the preceding drop-down selection.
Would some one look at this and let me know what I’m doing wrong?

Thank you,
Vince

 

[mark curtis]

You where nearly there.

You ref'd cboSalespersons but the combo was called salesperson.

I also changed the bound column to use Salespersonid as you may have several last names like Smith?

 

[T588]

Thank you!