Inserting Record VBA

[paulkc]

I have a form with a subform that shows a subset of information from my table based on the date on the master form. The details showing in the subform have a field that gives a sort order for that particular date. What I would like to do is be able to select a particular record and insert a record either above or below that record. I feel certain that what needs to happen is for the code to change the order field on all the following fields to the next number and then the new record would have the vacated order. Then the code would refresh the form giving the effect of the inserted field. I just don't know where to start on this. Thanks for any help you may be able to give.

 

[xenou]

Databases don't insert rows in any particular order (and not "above or below rows" either) - it's not something you want to be constantly managing. The best I can think if you really need to do this is to use a Double in the sort value field. If you want a row after 5 then give it the value 5.5. Or if if after 5.5 then 5.55, and so on. Or increment in 100's and leave plenty of room "in between". Better would be to use a natural sort key - order number, name, date, ID, and so on.

 

[paulkc]

I actually like that suggestion. I do need them in a specific order because it deals with a sequence of events. Thanks for the input.