On the Properies page of a Maintence form I have a four fields that have to be populated from a row from a dataset. I use the mmPicker to get the row, and once I select the row I put the field info into the text boxes.

Something like this (four of them):
Me.txtDeptNum.text = Me.oDept.DataRow.Item("DeptID")

A few other text boxes have already been filled in, and few have to be filled in after the data row is picked.

Then I save the data.

I noticed that the four text boxes that were populated like this didn't get saved in the SQL server row but the other popluated fields were.

However, if I did this:
Me.txtDeptNum.Focus()

for each text box, that is, enter the textbox and then leave it programmatically, the field data were saved. Somehow, just putting the field info into the text boxes, didn't update the row beneath it.

Any ideas on this behavior?

Thanks.