Records jumping in forms

[Guest]

We have a few forms that are behaving badly. When they are posting to a
record, it jumps to a different record. It is not even the next record or
the previous one. It is really random. It does not do this with every
record. Just certain ones. I have found no rhyme or reason to what it is
doing. Has any one else come accross a problem like this?

 

[Pat Hartman]

Do you have code behind the form that is requerying it? Requery reruns the
query that populates the form's RecordSource (it doesn't matter whether the
RecordSource is a table or a query. Either your query or a generated query
is run to populate the form). If it does not have an order by clause, it
might return the recordset in an unpredictable order and will reposition the
form to the first physical record of the recordset.

 

[Chris Reveille]

Do these computers have a mouse wheel? If so touching the
wheel will scroll records.

Chris

 

[Guest]

No. They do not have a scroll mouse.

Do these computers have a mouse wheel? If so touching the
wheel will scroll records.

Chris

 

[Guest]

No. There is no code behind it requerying it. There is an order by in the
properties. The records in the form remain in the order by order. It does
not move all the fields to a new record. As you tab through the form it
fills in fields that it is pulling form another unrealted record. It does
not do this with every record just certain ones. There is no rhyme or reason
to what it doing. There is no pattern at all.