I have a form that contains a Text List which I use to navigate between records in the database. On the same form is information related to the selected record. Most of the information is relevant to all records, but some of the information is only relevant to certain records, depending on the contents of a single field. Rather than having bizarre non populated information, I would like to format text display objects to vary according to the information in that sentinel field. I have managed to do this by setting a variable, with the contents determined by the sentinel field - however I am having to trigger that by pressing a button. I would like it to be triggered by selecting a new record on the list. My reading suggested one option, but the warning not to use it was so strong, that I didn’t dare!
"Triggering code when moving to a different record
If it exists, the .CurrentRecord procedure will be triggered when the user shifts to a different record. For example, this procedure is triggered when you move up or down in the database with the vertical scroll bar, or with the Find or Find Next commands. It could be used to initialize a variable or graphics object to display the newly current record. However, we recommend that you keep this procedure as short as possible, and actually strongly recommend avoiding use of the .CurrentRecord procedure altogether if at all possible, since it can cause performance problems.