Data going to All Records

C

cs_vision

I have a main form with 7 subforms linked via master and child fields. The
each subform is activated based on a combo box field selection. However when
I enter data in the subform, each records pickups the entry. Is there a way
to enter just for that record without the other 1000's taking the data?
 
J

John Vinson

I have a main form with 7 subforms linked via master and child fields. The
each subform is activated based on a combo box field selection. However when
I enter data in the subform, each records pickups the entry. Is there a way
to enter just for that record without the other 1000's taking the data?
Click to expand...

My guess is that NONE of your records are picking up the entry; and
that the subform's controls are unbound. Unbound controls will show
repeated rows of the same value (because there's really only one
control, displayed many times).

Check the Control Source properties of the dubform controls.

John W. Vinson[MVP]
 
L

Larry Linson

"John Vinson" wrote
My guess is that NONE of your records
are picking up the entry; and that the subform's
controls are unbound. Unbound controls will
show repeated rows of the same value (because
there's really only one control, displayed
many times).
Click to expand...

Oh, for a huge billboard that says:

Data lives in tables;
It is only displayed in Forms.

I think there is another database product, whose name I will not mention,
that actually misleads people into thinking that their data is form-related
rather than table-related.

Larry
 
J

John Vinson

I have a main form with 7 subforms linked via master and child fields. The
each subform is activated based on a combo box field selection. However when
I enter data in the subform, each records pickups the entry. Is there a way
to enter just for that record without the other 1000's taking the data?
Click to expand...

Ok... so what is the Recordsource (SQL please) of the mainform and a
representative subform? What are some representative Control Source
properties of the subform controls? Could you post the code which
"activates" the subform? And could you describe in detail what happens
when "each record pickups the entry" - is it running an Update query
updating the records in the table!? Or is it just displaying the
values on the Form without actually modifying the table?

John W. Vinson[MVP]
 
Top