Hi Craig
I've done that, but let me explain a little more, I don't think I made it completely clear.
If I use the either the check box of the menu list, and dynamically connect it to the database field (displayImage) I would only get the number (1=yes)(0=no) but as I would update it if the number is for example 1, it would go back to be 1 again.
And if I have a static menu option YES and NO, then I'm back to the beggening problem not being able to display the dynamic element from the table row(displayImage).
The other problem I first encountered was that I was trying to do all the update and displaying the image option on the update form. But it did not work, what was happening was that it was hiding the member as I would set it to NO(0) and show it again once I set it to Yes(1). That did not make sense to me, since I only wanted to be able to hide or show the image. Since the element was being updated to the displayImage field only.
So I had to make a separate page just to approve the image and it then worked.
Now the other criteria that you mentioned before "add some filter criteria to the recordset, something like "SELECT * FROM tblimages WHERE Display = 1" DID NOT WORK...
because when I make a link passing the parameter to the aproveImage page. On the displayImage page the parameter ended up looking like this.
======================
SELECT MembrosID, FotoLarge, DisplayImage
FROM membros
WHERE MembrosID = ParamMembrosID AND DisplayImage = 1
======================
then nothing was passed from the previous page.
Regards.
