I
islander
I'm building a form to enter, browse, and edit data. All of the controls on
the form are unbound. To browse, the user selects a value from a list box and
its click event fires a function that returns a single record recordset. The
function then cycles through every control on the form, and sets the value
for each control.
The rowsource of one combo box is a value list with 4 items, and the other
is a very small table (6 records, two fields) that displays column(0) of the
table, but not column(1). One combo box enters exactly what the user chooses,
the other displays column 0 but enters values from column 1 in the table -
i.e. selecting "Captain" inserts "cpt".
When displaying data, text boxes and option groups fill perfectly, but when
the function encounters a combo box, it returns the values in the recordset
correctly, but I cannot get it to update the form.
I remember seeing a solution to this problem on a web site or newsgroup
several years ago, but I can't locate it. Anybody have a solution?
the form are unbound. To browse, the user selects a value from a list box and
its click event fires a function that returns a single record recordset. The
function then cycles through every control on the form, and sets the value
for each control.
The rowsource of one combo box is a value list with 4 items, and the other
is a very small table (6 records, two fields) that displays column(0) of the
table, but not column(1). One combo box enters exactly what the user chooses,
the other displays column 0 but enters values from column 1 in the table -
i.e. selecting "Captain" inserts "cpt".
When displaying data, text boxes and option groups fill perfectly, but when
the function encounters a combo box, it returns the values in the recordset
correctly, but I cannot get it to update the form.
I remember seeing a solution to this problem on a web site or newsgroup
several years ago, but I can't locate it. Anybody have a solution?