Please help with the subform

[Ann]

I have a from with subform.

The subform is a continuous form having control source is
a table.
When we do data entry, sometimes after typing half the
word of the first field, the current record switches
order with previous record. And the previous order moves
down to the current record with the second field high-
lighted.
Don't know why is like this.

Any ideas?

The parent form 's fields are unbound fields with control
source are parameters passing from other form.
They are also link fields with subform.

Any suggestions would be appreciated
..

 

[William Taylor]

check the sort order of the recordset for the subform. It could be that it
is sorted on the first control. If this is the case then when the record is
created it sorts and the record moves to the sorted location.
2. If this does not solve the problem then open the subform in design view
and delete the controls and replace them on the form in the order of entry.
HTH

 

[John S]

Sounds like a problem in your form/subform link. The link is usually a key
in the table bound to a subform foreign key. You obviously are not using
this foreign key if your main form is unbound.

You don't actually need foreign keys with some databases (ie. MySQL), but
Access seems to be bound (no pun intended)to them. I suspect that your
problem will go away if you bind the main form to a table in your form
properties, provide a single link for the subform from that bound source,
and load all the other fields as you are doing now.

John S

Aylmer. PQ