a multi part question on my form

[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?

 

[CompGeek78]

- 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.

Why is your data structured like this? Are the fields in the smaller
tables the same as each other, as in the bigger table? Why not just
have the form input directly to your main table?

- 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?

You could set the default value of the field to Date(). That will
automatically fill your date field with that day's date.

Keven Denen

 

[Chris]

Ok...1st part
I'm not entirely familiar with queries, so I went with what seemed simple
enough in my mind. The main table consists of around 10 regions that arrive
into our print queue at different times through the night (I work in a print
shop). Since they are recorded at the time they arrive I have it broke down
by region so that it has its own individal form for each region.
2nd part
The dates to be input usually are but aren't always the date that it gets
put. One of my date columns is a barcode date, which is a past date. The
other is the date we received the files, which sometimes isn't the same day
we input the records. Thats why using a code for current date wouldn't
always work for me. Another one of the columns is a time column which is
simple enough to enter but its the same time for all jobs that come out in
that region.


Any ideas?

 

[Chris]

I had another way to try but I don't completel;y understand how to do it or
if it would work. If I made my tables out of just the constant information,
and used unbound text boxes in my form for the other information, is there a
way to get the info to save into the main table?

 

[elbyc]

Try it the other way around: Bind the form to the table where the
records are changing. Use combo boxes on the form. Bind them to the
changing fields on the table but use the constant tables as look up
values on the combo boxes.