Form to display correct ID information

S

SS

Hi

The subject is a bit misleading.

I currently have a form which gets updated and the ordering is ID (highest
number first).

The trouble is that obviously the ID keeps changing so if it's the wrong one
they have to keep going to the bottom of the page to go back one ID at a
time. Is it possible to have this form so if they change the ID it then
brings up the information for them which they can update?

Alternatively another form which when posted brings up their ID which can
then be upated.

This is the query if that helps

Update DISTINCTROW results
SET
Approve='::Approve::',Reject='::Reject::',Approve1='::Approve1::',Reject1=':
:Reject1::',
Approve2='::Approve2::',Reject2='::Reject2::',Approve3='::Approve3::',Reject
3='::Reject3::',
Approve4='::Approve4::',Reject4='::Reject4::',Approve5='::Approve5::',Reject
5='::Reject5::',
Approve6='::Approve6::',Reject6='::Reject6::',Comments='::Comments::',
Comments1='::Comments1::',Comments2='::Comments2::',Comments3='::Comments3::
',
Comments4='::Comments4::',Comments5='::Comments5::',Comments6='::Comments6::
'
WHERE ID=::ID::

Hope someone can help thanks Shona
 
Top