[AccessD] Problem Updating a Textbox

Hi Chester

Looks like that your problem is, that while you are editing a record, changing the Default Value for a control will not change the displayed value of that control until you move to a new record.

/gustav

>>> Chester_Kaup at kindermorgan.com 25-09-2007 23:32 >>>
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