Using checkboxes

[netman182]

Hey first post in this forum. i am having a brain fart right now and i cant remember how to do this. if anyone could help that would be great.

thanks

when an employee registers they must be approved by a manager to have access to the login pages.

I have a table with a record called approved. It's initial value is 0. I want a query to show all that are 0. but at the same time i need to be able to click a checkbox to make the value 1. I need this to be a mass check box list.

Here is an idea of the SQL:

Select * from users where approved ='0'

i then need ti to display all the rows and fields for each user where the approved is '0'

i also want to be able to update the approved with a checkbox.

how possible is this for someone to give me a hand.

thanks alot.

[djjjozsi]

I have a little program to create updater by checboxes.
Here