>>>>Hi Nick
>>>>Not it's not the report preview.
>>>>I did not explain my self the write way
>>>>The form containt information about the classification of the sirop.
>>>>It's composed with two table One table contant the header information an the second the detail on a the classification. When ia skip many time bettwen classification the refresh of my form slowing down ans so my pc two.
>>>>The grid d'osent show anyting if i go skiping bettwen record.
>>>>
>>>>Any tips.
>>>>
>>>>Ben.
>>>
>>>Do you show one-to-many in the grid? How the textbox is related to the grid on this form?
>>
>>Yes its One-to-many in the grid but the textbox contain the header information and the grid the detail information.
>>
>>the header information is the sirop producer descrpition
>>Ex.: Name ,Adrese Tele. etc
>>
>>The Grid Contain sirop baril description
>>Ex.: Baril number %Sugar %Pb Weight Etc..
>>
>>It's when i skip many time from one producer to a another that the trouble show up.
>>
>>
>>Thanks a lot
>>
>>Ben
>
>How do you populate the details grid? SQL SELECT based on the info in the header texbox I suppose?

Sorry for the delay
No i affect the control source with the name of the corresponding field of my detail table. Ex.: "ControleSource finarapdet.rapdebar" and i have define my relation betwen the table in my grid .

Thanks
Ben.