Word VBA Make Module Recordset Available To Form

[Speccy]

I have a recordset that is generated in a module and I need it to be made available to code running behind a form.

I have tried:

--Form Code

Public rsAuthor As ADODB.Recordset (declared on the form, not the module)
Public rsTypist As ADODB.Recordset (declared on the form, not the module)

--Module Code

With frmTelecopy
Set .rsAuthor = rsRecAuthor.Clone()
Set .rsPublisher = rsRecPublisher.Clone()
End With

------------------------------------------------------------------------------------------

I am using:

MsgBox rsAuthor.Fields("EmpNumber").Value to ping back a recodset value from the form but it doesn't work.

How do I make a recordset held in a module available to a form?

 

[SkipVought]

Hi,

CODE question ought to be posted in VBA Visual Basic for Applications (Microsoft) forum707

Please clarify between FORM (Word has FORM fields in the document) and UserForm constructed in VB Editor.

Skip,

_[red][/red]