Access 2000 Forms

Im trying to design a form in Access 2000 which displays the result of a query in a datasheet view. The query is designed by the user at run-time, the results of the query will be displayed in a datasheet. However, when results are displayed in a datasheet view i cant add any buttons, text, combo boxes etc to the form.

Basically i have a list of customers in a database. I want the user to search for the records they need using controls on the form. Then the results to be shown in a datasheet below.

Any ideas?

Do you need to be able to perform actions on more than one record at a time? If not, a lookup in the form header could be useful in performing the action desired.

No, I just need to view all the records returned as a result of a query - preferably in datasheet view. Only problem I found with datasheet view is that i cant see any of my buttons, combo's, text boxes etc, that i need on my form (for query input).

How would I do the lookup in the form header?

Only got half of it working... Maybe someone else can step in and help me with the VB code. I have the combo box displaying entries from the table, but I'm having trouble with having the combo box change the entry being displayed.

To create the combo box lookup created, here's how:
In the form header,
1) Draw a combo box while the wizard is on.
2) The first step in the wizard should ask if you want to look up the values in a table or query. Select Next.
3) Select the table you would like to lookup from and click Next.
4) Select the fields you would like to look up amd click Next.
(I recommend then selecting Finish.)

You can then adjust this lookup to show just a lastname, firstname or such using SQL in the RowSource property.