>I have two forms, frmMain.scx and frmReport.scx. On both of these I have cmbAssyDesc combo box that opens the same database and open the same table for the cmbAssyDesc items. I always get File in use program error. However, if I close one and open the other, I don't get this problem. Please help. Thanks, Sam

You have few choices here. One is using Private Data Session, another is to use AGAIN clause for USE commands.