Unfortunately, there are no 'events' associated with data-entry directly
into tables. Which is why you should force your users to use forms for data
entry. Sometimes you must implement user-level security to prevent direct
access to the tables.
Another alternative would be to create an update query that reads the table
record by record and updates any blank fields with the desired value. You
could then initiate this query from a form or an autoexec macro.
Fred
<br**********@hotmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Hi, I have a form that has an amount paid, billed amount, and expense
amount field. All three of these fields always has the same value. In
order to minimize keystroks, I'm trying to input the value in one of
these three fields and have the other fields fill in automatically. I
know a way to do this at the form level, the problem is that only one
of the three fields are being populated at the table level for these
fields.
Thanks for any help you can offer.