how do i create a report after selecting info from listboxes

[David Kennedy]

hi,
your help would be greatly appreciated

i have a form with 2 listboxes on it
the listboxes are 2 fields from a 5 field table
after the user selects 1 choice from each listbox
he/she will then click a command button to run a report
the report should include all the fields from the above
table filtered by the end user selections in the 2
listboxes (using a wizard)???

can anyone give me a detailed explanation on how to do
this?

you help would be greatly appreciated
thank you
David kennedy

 

[Azim]

Hi David,

-----Original Message-----
hi ,
thanks a million for the reply

the code works but when i select in the 2 listboxes i get
a message box asking for parameters??
when i hit the command button the report shows but with no
data in it
i also dont understand what u wrote:

form1 has the following objects

List2 : record source table1.field2

^^^^^^ should be field1
see below.

List4 : record source table1.field4

What I meant here is that the form should have two List-
boxes named List2 and List4

For the first List-box set the following properties:
Name = List2
Row Source =SELECT Table1.field1 FROM Table1;
Bound Column = 1
Column Count = 1
Column Width = 1"

For the second List-box set the following properties:
Name = List4
Row Source = SELECT Table1.field4 FROM Table1;
Bound Column = 1
Column Count = 1
Column Width = 1"

with the Table1 should have at least the two fields named
field1 and field4 for this to work and some test data.

Azim