tick box filter to produce report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that when a new product is created the tickbox called Print
Label is set to default to true and also have the ability to tick any
previous products just incase i need a label for restocks.

This tick box tells me that a ID label needs printing for the product. I am
wanting a form that acts as a filter so it will produce my labels from all
records that have a tick in the Print Label box.

I have managed to do this on a date created no problem but for some reason i
can't seem to get the tick box function to work. I have changed all
parameters that are required and i just keep getting the no data message.

Any help on this would be much appreciated..

PLease let me know if you require any other information.
 
DVM,
PrintLabel should be defined as a Yes/No field in your table.
Since you have a form already that allows you to add/delete/edit
products, you don't need another form to produce the report you want.
More detail in this regard would have been helpful... You shouldn't need
any PrintLabel "parameters" at all,
so I suspect this is your problem. Parameters for your DateField is OK, but
not needed for the PrintLabel criteria.

The query behind the form should be all you need to determine which
records will be selected for the report.
The PrintLabel field in that query shouldhave a criteria of
= True.
and that's all you need.
hth
Al Camp
 
Flipping heck of course it is.. Was looking to do it the complicated way...lol.

Thanks for that.

By the way do you know the code to globally set all the Print Label fields
back to False once i have printed the report. Just a simple button would be
good on a form.
 
I had a sneaking suspicion you'd be wanting that! :-)
A simple "Update" query run against the whole table will do the trick.
You'll set the criteria value of PrintLabel to = True, and the "update to"
value to = False.
hth
Al Camp
 
Al Camp said:
I had a sneaking suspicion you'd be wanting that! :-)
A simple "Update" query run against the whole table will do the trick.
You'll set the criteria value of PrintLabel to = True, and the "update to"
value to = False.
hth
Al Camp
Click to expand...
Ahhh right.. I could do that yes but i wanted to make it simple for anybody
else to reset them.. I was thinking of a form that when a radio button or
tick box was clicked and then submitted using a button it would then reset
the values to false.. I havn't got a clue where to start on that at all..

I will do your way as a temp measure for sure and thanks for the
information.. Much appreciated.. However :)) lol do you think the above is
possible and if so how..

Cheers mate
 
Back
Top