Strange happenings

[Cheeky]

I have a form with a drop down box and a sub form. Changing the entry in the drop down box changes the data in the subform. The subform draws its info from a table of data for all customers and just shows the data for the company listed in the drop down box.

It works fine for all but two customers. In these two cases it takes the data for the relevant customer and displays it, only it does not start at the top of the data for that customer, it starts halfway through and places those lines above the start line.

Not sure I've explained that too well but any ideas?

 

[TPugh]

Cheeky

If you are having problems with only two records, I would guess that the problem is with the two records.

Try deleting and re-entering the two records.

Its something to try anyway.

Tom

 

[Atomic Shrimp]

In your detail subform, have you specified a sort order for the record source?