Stumped on a continuous form

[Opal]

I can't find the original thread I started
on this one so I will start a new one....
Running Access 2003, I have a table
which lists 17 unsafe driving activities. I have
another table in which I wish to track a tally of
these activities based on user audits. The users
perform daily audits and if unsafe activities are
noted, I want another form to open listing the 17
activities and the user can enter their tally.

What I want is a subform that lists all 17 activities
and the user can fill in one or two or three or 17 text
boxes with the tally. I thought a continuous form
would do the trick, but once 1 number is entered
in the first text box, it repeats in all of them.....

I'm sure this is very rudimentary to resolve, I am
just stumped as to how to go forward. Any advice?

 

[John W. Vinson]

once 1 number is entered
in the first text box, it repeats in all of them.....

That implies that this is an Unbound textbox on the subform.

You're not trying to store data *in the form*, are you? The tally needs to be
stored in a Table; the form is only a tool to manage data stored in tables.
What are your tables, how are they related, and where in your table is this
tally field stored?

 

[Opal]

Hi John,

No, I am not trying to store in the form. I want to write the
tally to a table. One table lists the 17 unsafe activities
with an autonumber field as the primary key. The other
table has its own autonumber primary key, date field,
Unsafe actiivity field which is a number field and foreign
key to the first table, and a tally field which is also a
number field.

 

[John W. Vinson]

Hi John,

No, I am not trying to store in the form. I want to write the
tally to a table. One table lists the 17 unsafe activities
with an autonumber field as the primary key. The other
table has its own autonumber primary key, date field,
Unsafe actiivity field which is a number field and foreign
key to the first table, and a tally field which is also a
number field.

You say:

but once 1 number is entered
in the first text box, it repeats in all of them.....

This PROVES to me that the textbox in which you are entering the number is
unbound, i.e. has a blank Control Source. Doublecheck - if that is the case
there's something really wierd going on.

Perhaps you could post (again, if you did and it's gotten lost) the
Recordsoruce property of this form (in its SQL view).

 

[Opal]

Sorry, my confusion, yes the text box is unbound....

 

[John W. Vinson]

Sorry, my confusion, yes the text box is unbound....

So if you bind it can you do what you want?

 

[Opal]

No, I do not get the desired results when binding the form.
It does not bring up all 17 activities and when I enter
a tally in one text box, it repeats in all.

 

[Opal]

Sorry, the number does not repeat, my mistake.

However, to have the form unbound is my desired
goal. I am not the originator of this database, I am
just added a new functionality but in order for this
form to be compatible with all that was previously
done, it should be unbound.

 

[John W. Vinson]

Sorry, the number does not repeat, my mistake.

However, to have the form unbound is my desired
goal. I am not the originator of this database, I am
just added a new functionality but in order for this
form to be compatible with all that was previously
done, it should be unbound.

I do not know any way to have a continuous multirecord form that is also
unbound.

You might want to look into a DataGrid control and write (nontrivial) VBA code
to migrate data from the control to your table.

 

[Opal]

Thanks, John.

I found an example in another database here
where I work and have been able to get past
where I was stuck.

Thank you for your support.