Have a look at
http://support.microsoft.com/kb/216925/EN-US/http://support.microsoft.com/kb/200300>Hey Guyz!
>
>Quick question here!
>
>On my project, I have a global variable to know from witch form a form is called from so I can know witch type of datas I have to show.. So I have a window named frmAddWorkOrder, frmViewWorkOrder and another one named frmCustomers..
>
>Explanation of my situation : I add a workorder #123 to my customer #2.. So when I am done with frmAddWorkOrder I load the frmViewWorkOrder form to view the list of the Work orders we did for that customer. The SQL is sent properly with the proper conditions BUT to see the WO #123, I have to load the frmViewWorkOrder window twice because the first time it only show me the previous WO but not the new one. When I load the second time, It show the new on in the list.. Any idea WTHIGO??
>
>I am using ADOdc with Jet 4.0 sp8, MDAC 2.8 and VB 6.0 SP6!
>
>
>Thanks in advance!
>
>Yannick Lepage
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com