Pls Help with Subform Tab Control

[TotallyConfused]

I would like some help with the following: I have a main form and subforms
in a tab control (3 pages). The main form consists of doctor info. The
subform consists of patients associated with doctor and patient information.
Problem is in the subform/tab control the data is in datasheet view. In the
1st tab there are about 17 fields. When I update a field in a specific row
and hit the down arrow key the whole column changes. This only happens in
some of the fields. Like 2 text fields and 2 date fields and a couple of
CheckBoxes. All the rest of the fields will allow changes only to the
row/field where the entry was made.

I had posted before because all fields were doing this. I worked on it some
more and now only a few fields are doing this. I have exhausted myself
trying to figure this out and I can't find anything similar in this forum
that can help. Can someone please provide some relief and tell me why this
is happening? Thank you.

 

[NevilleT]

Strange problem but I would check out the query and the linking of the main
and subform. Perhaps you are displaying multiple records you should not be
due to the relationship. For example supposef you had a parent table, child
table and child birthday party table. If you want to show a listing of all
children and their parents (i.e. two rows per child for mum and dad), but you
create a relationship with birthday parties, you could end up with two rows
for every birthday party.

Bit hard to tell without more details.

Neville Turbit
www.projectperfect.com.au