var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Navigation Form help in access 2010
I currently have a form (customer orders 3 ) that automatically fills in 2 boxes in a form. When I try to use a navigation form with ths form I receive an error stating the form (customer orders 3) cannot be found. Below is the current code. Thanks for any Help
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] & """")
You mentioned a form "customer odrder 3".
But, what about the form "Enter Orders 3" ???
Also, your DLOOKUP code is wrong.
Look at Access help about DLookup function,
(attachment, word, zip).
sorry mistyped in the forum i meant enter orders 3
Send a short example of your mdb, (access 2000 or 2002-2003).
Thanks for the reply. The navigation form is new to access 2010. You would need that version to help. My question was answered at another forum.
Thanks for replying