I'm creating a page to edit/update a record. Part of the record is a field that's a list box. I want the choices of the list box to come from a recordset (that's no problem. I did that on the page before where the user originally entered the record). But I want the default value of the list box to be the value that was originally entered. So you get the value currently in the database, and clicking gives you all the options available to you (which come from a different table).
For whatever reason, I can get either the existing value, or all the available values, but not a combo of both. Any help would be appreciated.
For whatever reason, I can get either the existing value, or all the available values, but not a combo of both. Any help would be appreciated.