Hi,
We are trying to create an activeX that creates and manipulates the recordset, then the calling program can read the recordset fields. We did fine in an activeX dll with a public recordset. But are not having luck with the same logic in an activeX exe.. Seems that the recordset in the activex can pick up a new record & reflect the new records fields.. But the calling program does not stay in sync with the public recordset. Infact it does not reflect any info unless a .requery is used then both projects share the same information.. But when the activeX does a .movenext the activeX info changes, & the calling program remains stuck on the info from the requery.

I thought a public recordset meant everyone shares the common info.. What is making the public recordset act quirky in an ActiveX exe?? How can we fix this problem???
Thanks
Wenda & Ann