[AccessD] Problem Updating a Textbox

I have a form with a text box that displays the last date in a table. I
have another text box the display the last value for the field Oil1 from
the same table on the same form. It has its default value set with the
following command: =DLast("Oil1","tbl One Manifold Production for a Time
Period"). This works fine. When the user enter a new value in the text
box with the last date it runs a query to rebuild the table. I run the
code below on the on exit event of the last date text box. The problem
is that the text box Oil1 value does not update. I am not seeing the
problem so any suggestions would be welcome. Thanks all.

 

DoCmd.OpenQuery "qry One Manifold Production for a Time Interval"

Me.txtbxOil.Requery

Me.Repaint

 

Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799

 

 

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.