Referring to page 152, the following code ( declarations ) which I hoped would retain the value of sSid, when another form opens, to be referenced there, doesn't....

[CODEOption Compare Database
Dim pin As Integer
' Get the full path and name of the current database
Dim db As DAO.Database
Dim rs, rs1 As DAO.Recordset
' for Staff_ID as filter on Main Form
Public sSid As Long
Dim strFullpath, strSQl As String
Dim Msg, Style, Title, Response
Dim c As Long][/CODE]

Any ideas ? ( probably something simple, I've overlooked, knowing me ... ) Thanks.

"when another form opens"

What exactly do you mean by this?

The variable should be accessible from the instance of the form where the variable is declared. So, if your form is named "myForm", retrieve your public variable like this. e.g.

MsgBox "sSid = " & Forms("myForm").sSid

HTH.

Malc.

Many thanks. I see now, I simply treated it as if it were an available variable declared in the new form, i.e. TextBox.Text = sSid

Whereas in fact, I must reference the orginal form it was decalred in i.e.

TextBox.Text = Forms("frmMyForm").SSid
Thank you.