Form Fails to Update Table

[DoubleDownAgain]

I have a form which has a table as it's Record Source. The problem lies when a bound combobox or bound textbox is changed, the change is noted on the form but when I reference the value of the object it comes back as null. So I look in the table and the field has not changed. But if I requery the form then it takes.

I've never had this happen to me before, is there something I am missing?

 

[RichO]

Are you still in the current record when this is happening? Access does not save the current record to the table until you move off the record or force a save with:

DoCmd.RunCommand acCmdSaveRecord

 

[DoubleDownAgain]

Still in the current record. I've never had to the past, or maybe I just didn't notice it.....

I will give that a try, I'm sure that it will work.

Thanks!

 

[Pat Hartman]

You just didn't notice it. This is normal behaviour.