I have one screen which has some buttons like save, approve, delete etc. when I
click approve button, Another screen will be displayed with fields exceedance
date 03/02/2005. etc and table with fields moth, year and approval status. The
data will be displayed in the table as below.

exceedance date: 03/02/2005


Month: Year: Approval status:

January 2005 approved
February 2005 not reviewed
March 2005 not reviewed
April 2005 not reviewed
may 2005 not reviewed


The problem is that the only approved data should be displayed in the above
table
not reviewed data.

I am also sending the code. Could you please tell me what could be the problem?


I hope you guys understand my problem

I don't see the code, but I think that what is wrong
is the SELECT statement. Do a SELECT without the WHERE
part and pass the where critiria once the button is
click!