save changes to row source of combo at runtime

[Jhitch]

I have a Recent Records combo box where the row source is updated every time the record is changed. I want to keep the row source text as it is at the end of the session - when the form is closed. I have tried all sorts of saving methods in form view and design view and am getting nowhere. Usually it doesnt save at all, sometimes it saves row source text from a previous session! Does anyone know how to do this please?

 

[Jhitch]

Yes thanks Tony. I have used the table option which works ok. I would still like to understand why it sometimes saves something in the row source.