C
Chris
I have several smaller tables for different regions that I have appended to a
main table. There are 7 fields to the table, 3 of which are constant with the
same information every day. I want to use these smaller tables only for a
template in a form. Currently I have a button to append to the main table but
when I close the form, the information is saved in the small table as well.
Is there a code or macro of some type that I can use to clear the 4 fields
without having to manually delete each entry?
If so, that would be quite beneficial. If there is some other way of
achieving this that would be even better.
The other piece to this form predicament is that since I have it broken down
by region, 3 of these 4 columns that change daily will be identical for this
entire form. My form is set up in a tabular view. Is there a way that once
the information is put into the first line of a date column that it autofills
the rest of the date column below it with the same date?
main table. There are 7 fields to the table, 3 of which are constant with the
same information every day. I want to use these smaller tables only for a
template in a form. Currently I have a button to append to the main table but
when I close the form, the information is saved in the small table as well.
Is there a code or macro of some type that I can use to clear the 4 fields
without having to manually delete each entry?
If so, that would be quite beneficial. If there is some other way of
achieving this that would be even better.
The other piece to this form predicament is that since I have it broken down
by region, 3 of these 4 columns that change daily will be identical for this
entire form. My form is set up in a tabular view. Is there a way that once
the information is put into the first line of a date column that it autofills
the rest of the date column below it with the same date?