access 2010 navigation form

[araman]

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

 

[AccessJunkie]

I believe I've already helped you on UtterAccess where you posted the same question:

http://www.utteraccess.com/forum/Access-2010-Navigation-Fo-t1959532.html

--------------------
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Author - Microsoft Access 2010 Inside Out
Co-author - Microsoft Office Access 2007 Inside Out
Access 2007/2010 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

 

[araman]

Yes, you most certainly did.thanks you