auto copy in subform

[Humbled Learner]

Good afternoon,

Using the orders management database from online templates, I've added a
column for a tracking number in the subform.

So, in the original database, if the first row had information, the subform
would tab thru the second row and if left bank, it would tab to a new record.
If you added information to the second row, it would tab thru the 3rd row
and if left blank it would tab to a new record.

In my case, if you tab to thru the second row and do not add information it
will tab to the next record... works fine, but... if you add information to
the 2nd row, it it auto copies from the block above... I don't need autofill
or auto copy, I just need a new record or line added for the same client.

Any suggestions? And Thank You for your help!


Thank You

 

[John W. Vinson]

Good afternoon,

Using the orders management database from online templates, I've added a
column for a tracking number in the subform.

So, in the original database, if the first row had information, the subform
would tab thru the second row and if left bank, it would tab to a new record.
If you added information to the second row, it would tab thru the 3rd row
and if left blank it would tab to a new record.

In my case, if you tab to thru the second row and do not add information it
will tab to the next record... works fine, but... if you add information to
the 2nd row, it it auto copies from the block above... I don't need autofill
or auto copy, I just need a new record or line added for the same client.

Any suggestions? And Thank You for your help!


Thank You

It sounds like the controls in your subform are unbound (have nothing in their
CONTROL SOURCE property). An unbound control will display the same data in
every row, since there's actually only one control displayed many times.

What is the Recordsource property of the subform? Is it in fact the query
based on the table that you modified? Does the query contain the newly added
field?