Combo Box for query

[colinmunnelly]

I have a paremeter query that prompts the user for a name of a consultant, Then it creates a report on that consultant. I want the user to be able to select the consultant from a combo box instead of the query created message type box.

 

[Twin]

Hi,
on the form containing your combo box, create a text box that has your combo box as a control source. Then just use the text box as a criteria for a query.

Not elegant, but it works.

Chris

 

[raskew]

You can use something similar to this as the Row Source for your combo box (I used the Employees table in Northwind for this example):

SELECT  Employees.EmployeeID, [LastName] & ", " & [FirstName] AS name
FROM Employees
ORDER BY [LastName] & ", " & [FirstName];

Set:
Bound Column: 1
Column Count: 2
Column Widths: 0"; 1"

It sounds as though you've already got your report calling mechanism set up. If so, place that code in the combo's After Update Event.

 

[colinmunnelly]

Sorted it out without with a combo box as a selector. Thanks for your help.