Update table fields

[Skip Bisconer]

I have a form that builds a temporary table with two fields. One is a date field entered on opening the second field is numeric. The date will remain the same until the process is finished. My problem is unless I put the date in again it will not update the date field for the next numeric entry. I would like not to have to enter the date field but have it post with each numeric field on the enter key. Make sense?

 

[Skip Bisconer]

Forget this post! I figured a way to do it by adding an unbound text box to put the date in then on the before event on the numeric field I coded the date field to equal the unbound box. Made the date filed property visible to no and it accomplishes what I need to happen.

Thanks for looking anyway.