run-time error '2450' microsoft office access can't find the form

[secretary]

I've written the following procedure for my form:

Private Sub PrintFamily()
    Dim strLastName1$
    Dim strLastName2$
    Dim strFamily$
    strLastName1 = Forms![Member Entry Form]!txtLastName1
    strLastName2 = Forms![Member Entry Form]!txtLastName2
    strFamily = strLastName1
    If strLastName1 <> strLastName2 Then
        strFamily = strLastName1 & "/" & strLastName2
    End If
    Me.txtFamily = strFamily
End Sub

But then I get the following error:

run-time error '2450' microsoft office access can't find the form referred to in a macro expression or Visual Basic Code

What's the issue?

[vicrauch]

There are only two lines in this module where a form is referenced, so the issue is with those two lines. The form mentioned here "Member Entry Form" must be open for Access to "see" it. I will assume the form is not open when you run this procedure. Or else, you have the name misspelled here. Check for spaces, could be two spaces in the name of the actual form, or maybe no spaces in the actual form name.
I would like to suggest, in the future, leave the spaces out of any object or variable name. Saves having to type those brackets, and it is just as easy to read:
Member Entry Form or MemberEntryForm

[secretary]

The unopened form was the issue.
I however, decided not to use the form as a source, but tables instead:

Private Sub PrintFamily()
    Dim strLastName1$
    Dim strLastName2$
    Dim strFamily$
    strLastName1 = FirstMember.FirstName
    strLastName2 = SecondMember.FirstName
    strFamily = strLastName1
    If strLastName1 <> strLastName2 Then
        strFamily = strLastName1 & "/" & strLastName2
    End If
    Me.txtFamily = strFamily
End Sub

Yet now I get the following error:

run-time error '2465' microsoft access can't find the field '|' referred to in your expression

Incidentally, I took your advice and renamed all my objects without spaces.

[pbaldy]

You can't reference a table that way. You can either use DLookup():

DLookup Usage Samples

or open a recordset on the table.

[vicrauch]

Thanks Paul. I was wondering where FirstMember and SecondMember came from.
BTW did you see my question in the Programming forum about how to iterate through a custom Collection? I was thinking you might be able to help. Thanks!

[vicrauch]

Secretary,
You said, "Incidentally, I took your advice and renamed all my objects without spaces." I think you will really enjoy this change.

[secretary]

DLookup solves it!
Thanks!

[pbaldy]

We were happy to help!

[uronmapu]

I have this problem too,

My Code:

Private Sub Form_Open(Cancel As Integer)

'Me.ID.Value = Forms!Menu!lstItems.Column(0)
'txtid.Caption = lstItems.Column(0)
Me.Title.Value = Forms!Menu!lstItems.Column(1)
Me.Full_Name.Value = Forms!Menu!lstItems.Column(2)
Me.Mobile.Value = Forms!Menu!lstItems.Column(3)
Me.Email_Company.Value = Forms!Menu!lstItems.Column(4)
Me.Email_Personal.Value = Forms!Menu!lstItems.Column(5)
Me.Company_Name.Value = Forms!Menu!lstItems.Column(6)
Me.Home_Address.Value = Forms!Menu!lstItems.Column(7)
Me.Company_Address.Value = Forms!Menu!lstItems.Column(8)
Me.Position.Value = Forms!Menu!lstItems.Column(9)
Me.Data_Source.Value = Forms!Menu!lstItems.Column(10)
Me.Remarks.Value = Forms!Menu!lstItems.Column(11)
Me.Telephone.Value = Forms!Menu!lstItems.Column(12)
Me.Fax.Value = Forms!Menu!lstItems.Column(13)
Me.Country.Value = Forms!Menu!lstItems.Column(14)
Me.Birthday.Value = Forms!Menu!lstItems.Column(15)
Me.Category.Value = Forms!Menu!lstItems.Column(16)
Me.Web_Page.Value = Forms!Menu!lstItems.Column(17)

End Sub

[pbaldy]

Is the form open?