Using Checkboxes to add data to a table.

[Skip Bisconer]

I have been having trouble developing this form for a couple of days. It
seems the solution should be simple but so am I. I have an input form with
four text boxes. I need to use the same data and create a new line in the
table for up to but not always 9 different company positions. I was given a
possible way of keeping the info on the form for the next position using the
AfterUpdate event and setting the default back to the same box. But in using
his suggestion I get #NAME? for the boxes with text when I select the next
new record. The boxes with numbers come back the way he said it would. I
can't seem to work around that. So I thought I would look at it a different
way.

The way I have it set up I am using a combobox to select a position and
update the record but I have to retype all four text boxes to select when I
update the table and go to a new record for next position. What my question
is...Is it possible to put all the positions on the form and check the
applicable position(s) and have all the true's add to the table from one Add
Record button? And if so give me an idea of the VBA involved?

 

[John W. Vinson]

I have been having trouble developing this form for a couple of days. It
seems the solution should be simple but so am I. I have an input form with
four text boxes. I need to use the same data and create a new line in the
table for up to but not always 9 different company positions. I was given a
possible way of keeping the info on the form for the next position using the
AfterUpdate event and setting the default back to the same box. But in using
his suggestion I get #NAME? for the boxes with text when I select the next
new record. The boxes with numbers come back the way he said it would. I
can't seem to work around that. So I thought I would look at it a different
way.

The way I have it set up I am using a combobox to select a position and
update the record but I have to retype all four text boxes to select when I
update the table and go to a new record for next position. What my question
is...Is it possible to put all the positions on the form and check the
applicable position(s) and have all the true's add to the table from one Add
Record button? And if so give me an idea of the VBA involved?

STOP!!!

You're beginning in the middle.

Your tables are fundamental. If you're starting (either physically or
logically) with the form you're going to paint yourself in a corner.

What's the structure of your table or tables? If you have nine table fields
for positions, you're on the wrong track.

Please post the actual structures of your tables.

 

[Skip Bisconer]

I have a table with Fields Policy, Description, Interval, Time, Position.
There are 148 different Training Policies in effect at the moment. The
Driving Position has about 124 policies that apply to them, Office Position
about 66, so on and so on.

I have this great little program that tracks all employees training records
working for us now but I did not anticipate the need to add a new training
policy. The training department needs to schedule training by department or
by employee or position. All this to comply with government regulations for
record keeping. Every thing is handled but this Add New record issue for this
table. Since my post I have discovered how to make the data stay on the form
using the After Update event but if I could use check boxes to indicate which
position the new training applies to it would speed that part of the form up
a little. All the others are covered by making a change to this table.