Parameter query / check box..

[Brave Hearts]

i have created a small address book in ms access. using parameter
query i'm able to get the required address and able to print..
But i have sometimes 10 or more for that i have created a query as
In(2,7,9,11) like that to extract the records each and every time..
this is also tedious to get all those hundreds of records by each time
selecting the query..

Now i would like to create an array to extract but plz help me in
coding..

my requirement is .. i have 10 records to be printed using their id
numbers..

so when the user click on the "print" on the address form . it should
prompt the user to give input how many records would like to print?

if the user gives any number like 5 it should prompt for five times to
take the input as query to extract the records by their id number and
preview should be generated .

or other wise..

i would like to have a check box on the report form so that only
checked item will be printed..
how can i get that.. Plz help..

 

[Duane Hookom]

Place a multi-select list box on your form for the user to select one or more
records. Then use some code (lots of examples on the web) to loop through the
selected records to build a where condition to use in the DoCmd.OpenReport
method.

Come back if you can't find any sample code.

 

[Brave Hearts]

sorry for late reply.. i would be so thankyouful to you if you could
reply with code....
thankyou once again...

 

[Duane Hookom]

http://allenbrowne.com/ser-50.html

 

[sweetummy]

thank you verymuch very nice information./.