First record has become last record?

[Manuel10]

Hi,

I have a form with a subform and a subsubform. In both subforms I encounter the strange behaviour that the form starts with showing the second record in the list. When going to the last (key)record, the subform ends up showing the first record. The keyrecords are counted as 1,2,3 etc.
There are no anomalies present in all the keyrecords of the different tables at all! I only occurs with 1 or 2 record of the (sub)form.
So what explains this behaviour?

Has anyone encountered this before?

Thanks! Manuel.

 

[PHV]

Does have the underlaying SQL an ORDER BY clause ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Manuel10]

Hi PH,
Thanks for your reply.
I am not sure if I understand you correctly.
I only have several comboboxes on the main form to select items. These comboboxes use the ORDER BY clause to order the items. But I cannot see the connection to my problem ... yet.

Regards, Manuel.