move records up And down

[azhar2006]

Hi All


I have a form (continuous) that is a page on another form. This form is used to type in parts and descriptions.
What I want to be able to do is move (records) up or down on the form. Does anyone have any code
or advice on how to accomplish this?

[ItsMe]

I would probably add a column to the table and dedicate it to sort order.

[azhar2006]

How is that (ItsMe)
See the picture I've been so mean

[ItsMe]

That looks about right. Code behind the buttons can change the value that determines the sort order. All of the records would have to be updated. In the click event for each button, I would add code to Enable = False in the first line and Enable = True after the records were updated.

Let us know how this works...

[azhar2006]

Yes ItsMe
Thanks for the help