>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

Are you adding tables to the Data Environment (dragging them from your database lists into the DE window?) or opening and closing all tables via code? If the latter then you're missing out on much of the beauty of using "visual".

In the DE, you set a property of Private Data Session, equiv. to Open ... AGAIN (which you learned earlier).

Also you can set the DE's AutoOpenTables and AutoCloseTables properties.

So set these, drag your required tables into the DE (in the earlier example you could have dragged several copies of the table into the DE, one for each combo), then forget about them.

HTH

Terry