move up and down

[Seb]

Hello all

Got a question that I've never seen done in Access....
I have a DB I'm creating that creates pickup runs....(guy goes out and collects stuff) I'll need to get a subform showing the run items and be able to move them up or down according to the way in which the driver is going to do the run

Any ideas guys?
I've got no idea where to even start

 

[lightray]

Just straight out of left field here. Perhaps have them listed in a column, each with an number combo box beside them, drop down 1 to as many items on form.
once the form is populated. select your alternate order via the combos.
Then a sort of refresh key that does a re-write of the positions. All positions could be in a temp table so you don't effect the original record when switching them about. sort of query in it append it back maybe?
That sound like a good idea? lightray

 

[MStCyr]

I've posted a sample database that does what you're looking for, namely the example MoveRecord.

Hope this helps.

Best regards

Maurice


http://www.access-programmers.co.uk/forums/showthread.php?t=103456

 

[Seb]

Lightray, I was thinking the same thing.....but then MSTCYR did it exactly the way I wanted it. MSTCYR you're a legend! Could you kinda explain the logic behind it though? I've never seen the rs.bookmark thing before but its exactly what I was thinking

 

[MStCyr]

The Bookmark property with forms to set a bookmark that uniquely identifies a particular record in the form's underlying table, query, or SQL statement.

Maurice St-Cyr