Hello, i have a simple form called "enter orders 3" it simply adds information typed in to a special orders table. On the form when the user enters a phone number the customer first name and last name fill two boxes labeled as such with an afterupdate event. This allows the data entry person to see the name that is recorded in the customer table whose phone number they typed in. This all works fine until i try to use the form in access 2010 by opening it in a navigation form. i receive a message form enter orders 3 cannot be found. Any suggestions? Thanks
The Code in the after update event is
Private Sub Phone_Numbers_AfterUpdate()
Me.Customer_First__Name = DLookup(" [Customers]![Customer First Name]", "Customers", " [Phone Numbers]=""" & [Forms]![Enter Orders 3]![Phone Numbers] & """")
Me.Customer_Last__Name = DLookup(" [Customers]![Customer Last Name]", "Customers", " [Phone Numbers]=""" & [Forms]![Enter Orders 3]![Phone Numbers] & """")
End Sub
The Code in the after update event is
Private Sub Phone_Numbers_AfterUpdate()
Me.Customer_First__Name = DLookup(" [Customers]![Customer First Name]", "Customers", " [Phone Numbers]=""" & [Forms]![Enter Orders 3]![Phone Numbers] & """")
Me.Customer_Last__Name = DLookup(" [Customers]![Customer Last Name]", "Customers", " [Phone Numbers]=""" & [Forms]![Enter Orders 3]![Phone Numbers] & """")
End Sub
