There are acouple of things you can try.
Close the DE recordset
You would replace rsCommand1 ine the code above with the name of the recordset in your DE. The recordset name is the command name with a "rs" in front of it. ( command name is "Names" then recordset name is "rsName"Code:If de.rsCommand1.State = adStateOpen Then de.rsCommand1.Close End If rpt.show
or try requerying the recordset
rpt1.show
de.rsCommand1.requery




Reply With Quote