T
Tracey
The me.combobox.requery will not work because the value of
the combobox must be something within the list or empty.
Lets say you type something in the combobox that is not in
the list, the "add to" form opens in whatever mode you
add data and close the form which forces the requery, the
combobox still has the value that you typed into it (which
wasn't in the list to begin with), which is not in the
list yet, an error occurrs because of that. even clearing
the contents of the combobox generates and error
because "null" is not in the list? The error is occuring
because the field cannot requery while text is present. I
think I understand how to write the code to force the
requery, I am having trouble clearing data or the new
record before forcing the requery. Any Ideas?
the combobox must be something within the list or empty.
Lets say you type something in the combobox that is not in
the list, the "add to" form opens in whatever mode you
add data and close the form which forces the requery, the
combobox still has the value that you typed into it (which
wasn't in the list to begin with), which is not in the
list yet, an error occurrs because of that. even clearing
the contents of the combobox generates and error
because "null" is not in the list? The error is occuring
because the field cannot requery while text is present. I
think I understand how to write the code to force the
requery, I am having trouble clearing data or the new
record before forcing the requery. Any Ideas?