Insert query in a form

[Syed Zeeshan Haider]

Hello Everybody,
In a Form of Access 2003, I have a ListBox with some data in it from a
certain table. Now I want to run a query based on the item selected in the
ListBox. It is a rather simple query. It will use ListBox items as criteria.
I have already successfully designed the query.

The problem is how to display it in the form. The query could return from 0
recordset to any number of recordsets as it depends on the criteria it is
provided with; therefore, I cannot put a fixed number of controls on the
form and I want to avoid creating them dynamically.

Is there any way that I could display the result of the query in the form
without creating any controls (TextBox, Label etc.) rather I could just
display the result in its original Datasheet View?

Thank you,

 

[Arvin Meyer [MVP]]

Here's a sample of how to do what you desire:

http://www.accessmvp.com/Arvin/Combo.zip

 

[Syed Zeeshan Haider]

What an idea! Bravo!
It worked perfect. Your help is much appreciated.

Thank you,
--
Syed Zeeshan Haider

Here's a sample of how to do what you desire:

http://www.accessmvp.com/Arvin/Combo.zip