Access Modules (VBA Coding) - Renumber order field in a table. Move a Record Up/Down in a Continuous Form ! - Microsoft Access / VBA answers. On 29 Jun 2005 06:22:56 -0700, "Prakash" wrote: Hi !!
In a Continuous Form with say 10 records, I'd like to have 1 buttonwith an "UP" Arrow & another button with a "DOWN" arrow. By pressingeither the Up or the Down Arrow, I'd like the user to be able to MOVEthe records up or down the order. This is not trivial. Move a record up or down within a form. > code, but I am not clear on one thing one thing.
"My query" is the query that > pulls up the set of records that I want to reoder within....correct? Correct. In other words, the query that the form is based on.