Re-assign values to records

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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".
Click to expand...

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
 
Back
Top