Re-assign values to records

[Guest]

I have a main form with a subform - the subform can contain from 1-3 records
(no more than three allowed). Each record is designated a, b or c.

When the form is closed, I would like the records in the subform to
redesignate, i.e., if someone deletes b, then "a" and "c" would redesignate
to "a" and "b".

Can anyone help? Thanks for any clues you can provide.

 

[Tim Ferguson]

When the form is closed, I would like the records in the subform to
redesignate, i.e., if someone deletes b, then "a" and "c" would
redesignate to "a" and "b".

You should be able to put a function together like

OrderLetter =
Chr$(Asc("a") + DCount("*","MyTable", _
"MainID = " & MainForm!ID & _
" AND OrderLetter < """ & Subform!OrderLetter & """" _
))


.... if you see what I mean

HTH


Tim F