Dear Sir, Sorry for again with same question, before I say anything I will submitt to you my Command what I use I think its a better way to solve my problem. MySql = "select * from _ Location where ItemNo" If MyItem.state = 1 Then _ MyItem.Close MyiTem.Open MySql, Data, asOpenKeyset,...