Hi,

I have a dataGrid (VB6) being filled from a cursor defined through a command from the DataEnvironnment (Acces database).

The data gets to the grid (datasource and datamember are ok). The grid gets refreshed by selecting through a combobox. My problem is that sometimes the grid is being refreshed with nothing or wrong data.

This is the code to refresh the grid (gintID being id given from the combo):

strsql = ""
strsql = strsql & "SELECT a.*, b.nom_affichage_menu "
strsql = strsql & "FROM acces_tmp a, interface b "
strsql = strsql & "WHERE a.usager_id = " & gintID & " "
strsql = strsql & "And a.interface_id = b.interface_id "
strsql = strsql & "ORDER BY b.nom_affichage_menu"

deStructures.rscmdUsrPermission.Close
deStructures.rscmdUsrPermission.Open strsql
deStructures.rscmdUsrPermission.Requery
Set dbgPermission.DataSource = deStructures
dbgPermission.Refresh

Any ideas?

TIA.