Refreshing a form after record update (through PHP)

Applications Forms
, ,
#1

I have an application using a form that presents in single record format.

It only displays records that have not been “approved” and the user needs to approve them by pressing an “Approve” button.

I have written the button’s PHP code for the SQL update to “approve” and that works properly. However afterwards the display does not refresh to show the next record (or in fact the first record now meeting the “not yet approved” criteria) - nor does it show the navigation bar properly.

What am I doing wrong? How do I force the form output to refresh with the next record / first non-approved record?

Thanks in advance…

#2

I assume that your sql has been set to select the first non-approved record? then after hitting your (custom?) button you have to apply a ‘exit(ref)’; It will reload your application.