I have a custom form set up as a parameter query dialog box. I currently have only one control (cmbNames) on this form which allows the user to select a sales person name from a combo and search for projects by sales person. I use the following in the query criteria.
[Forms]![Project Database - Project Search]![cmbNames]
This works fine but I now need multiple seach criteria which will require two
text boxes (txtAccount & txtCustName) to enable me to futher refine the search, for example to find projects by customer & salesperson. I need all three controls to work together.
Can I use.........
[Forms]![Project Database - Project Search]![txtAccount]
[Forms]![Project Database - Project Search]![txtCustName]
and expect these all to work togther on the same query.
[Forms]![Project Database - Project Search]![cmbNames]
This works fine but I now need multiple seach criteria which will require two
text boxes (txtAccount & txtCustName) to enable me to futher refine the search, for example to find projects by customer & salesperson. I need all three controls to work together.
Can I use.........
[Forms]![Project Database - Project Search]![txtAccount]
[Forms]![Project Database - Project Search]![txtCustName]
and expect these all to work togther on the same query.