Reload query Not the total dataset

[fhiemstra0507]

Hi

I have a listbox that I want to update when the an item is updated/added.
Now the listbox is attached to a query. Now I tried to just reload the
query by modifying the forms loadDataSet and filldataset subroutines but
when I do that the table values do not mesh which the lstbox anymore. As
well, I have looked at the data adapters select statement to try and update
it but to no avail.

Any suggestions?

The code below is the code that I used to reload the query.

Thanks in Advance

Bill

public void qryLoadDataSet( )

//--------------------------------------------------------------------------
-
//
{
MemSys.dsFamily objDataSetTemp;
objDataSetTemp = new MemSys.dsFamily ();
try
{
this.FillDataSe t(objDataSetTem p);
}
catch (System.Excepti on eFillDataSet)
{
// Add your error handling code here.
throw eFillDataSet;
}
try
{
objdsFamily.qry FamName.Clear() ;
objdsFamily.Mer ge(objDataSetTe mp);
}
catch (System.Excepti on eLoadMerge)
{
// Add your error handling code here.
throw eLoadMerge;
}

}


//--------------------------------------------------------------------------
-
public void qryFillDataSet( MemSys.dsFamily dataSet)

//--------------------------------------------------------------------------
-
//
{
dataSet.Enforce Constraints = false;
try
{
this.connFam.Op en();
this.daFQryFamN ame.Fill(dataSe t);
}
catch (System.Excepti on fillException)
{
// Add your error handling code here.
throw fillException;
}
finally
{
dataSet.Enforce Constraints = true;
this.connFam.Cl ose();
}

}