I have dimensioned a recordset as global and open it with an OpenRecordset
containing an SQL statement.  This works fine -- but:

On the first call to a modal form which also uses this recordset,
I find a completely different record in it.  This first appears in the
Form_Activate property of the modal form.

I have checked and double-checked the usual "did I dimension it somewhere
else?"  "does this form think it's a different variable?" "did some other
routine do an OpenRecordset or CreateDynaset or move the pointer?"

Answer to all these: no.

It seems that the global recordset isn't truly global.  Anyone else been
here?  Comments? Anyone have a workaround?

Thanks in advance.

Reg Jacklin
Contract Programmer / VB Instructor / Columnist