Thanks to those who responded to my previous post, but I don't think you undersatand my question.
I'm trying to populate the select multiple form field on an 'update' form with choices that the user had selected on a previous visit.
(I know how get info from a select multiple form field into the database.) What I don't know how to do is display to the user, using drop-down boxes on an 'update' form, the various multiple selections they had previously selected on some previous visit to the site. Their previous selections should appear 'highlighted' in the drop down box.
For example, using a select multiple field of the 50 states, if they had selected Alaska, Alabama and Ohio when they logged-in last week, those selections would now be highlighted in a select multiple drop-down box on the update form when they visit the site today. The drop-down box would show all 50 states with their 3 choices highlighted (from the previous visit) when they visit today and they could add or change the states selected and update the database. Any ideas? Thanks very much for the help.
