Tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Connie - 11 Feb 2004 15:19 GMT

I would like to know if there is any way to make a
field/column in a table be autofilled based on what is in
another field/column? To give you an example - At my
work, we use Access to keep track of all of our tax
payments. We want to know if it's possible to put in a
completed date for a tax extension and have the extended
due date for that state be automatically filled in for the
actual state return which is a totally separate record in
the table. I know we can do it in a report or form but is
it possible in a table? If so, can someone tell me how to
do it?

Reply to this Message

Tim Ferguson - 12 Feb 2004 13:06 GMT

> I know we can do it in a report or form but is
> it possible in a table?

No, and there is usually no reason to want to. Is there any reason why the
ExtendedDueDate would ever change with respect to the CompletionDate?

If they always go together, then you have only one bit of information and
it should be stored once.

On the other hand, if you can extend the ExtendedDueDate without altering
the comletion date, then they are two bits of information and do indeed
need two separate fields. In this case, you can be nice to the user and
enter a suggested ExtendedDueDate on the form when the user changes the
txtCompletionDate control on the form: use the AfterUpdate event. But you
would not want the program to overwrite the value if the user has already
put in the real ExtendedDueDate so you have to be very clear what takes
priority over what.

Hope that makes sense.

Tim F

Reply to this Message