I have an subform in a tab control that used two combo boxes to pick values from a query. The vales are then used in an update query to a table.
The update query runs perfectly when run from the form itself, however when I run the update query from within the form within a tab control I get "didn't update ##field(s) due to a data type conversion error". The fields are all text and the lengths are the same. Why would this run right from the form but give the error when the same form is embedded in a tab control?
If I ignore the error and click though it changes all the data in the AgentName field to a nul value.
I have tried sending the combo box values to text boxes and also to global variables but still get the same error when update is run from within the tab control.
- Many thanks in advance...
"UPDATE Sales_Tracking SET Sales_Tracking.AgentName = " & _
"Replace([AgentName],Forms!frm_Administration!tabctrl_Admin!cmbOldAgent, " & _