Using a combo box as report criteria (1 Viewer)

[IainG]

Can someone tell me how to use a combo box from a form as the criteria for a report? My report is using a select query and this is the code from the criteria box in the query
Like [Forms]![Estimate Details]![Estimate]
My report come up blank!

 

[Uncle Gizmo]

What does MsgBox " >>> " & [Forms]![Estimate Details]![Estimate]

Show?

 

[boblarson]

Like [Forms]![Estimate Details]![Estimate] & "*"

but check to see that your combo is returning the value you want. It may be doing something different (like using a key ID where you think it should be text). If so, you can change the bound column from 1 to 2 and see if that helps.

 

[IainG]

Fantastic,
I used the msgbox to find out that I had indeed bound the ID field!

Many thanks for your help guys.