I have looked for answers and I have shuffled around every variably, quotation mark, form reference, everything that I can think of to get this DLookup to work. Here's the background information on what I'm trying to do here:

PrimaryRouteID = short text data (key player in this lookup)

SignSumtxt & SqFtSumtxt = textboxes where I want my DLookup values to show (via changing the control source in VBA)

PrimaryRoadInventoryTotals = The query that has the pertinent information that I want

PrimaryRoadInventoryMaster = Form nested in Navigation form (main form to use)

The rest I'll explain here: I'm designing a DLookup function that finds a quantity on the PrimaryRoad InventoryTotals query using the PrimaryRouteID taken from a textbox on a form that is nested in a Navigation form. This DLookup functions within the form by itself, but I've been struggling to fix it to work within the Navigation form. 

It's my understanding that since I have put the MasterForm in the NavForm, it is now nested in the NavSubform, and you have to reference values inside the NavSubform, not just the form that you're working in. I seem to have figured out the correct syntax (I think) to grab the value I want, but my DLookup still does not function like it needs to. In the version below, both textboxes that have DLookups assigned to them have #Name? errors. I cannot for the life of me figure out what to do!

The Code (separated for easier viewing):

```
Private Sub RouteSelectCombo_AfterUpdate()
SignSumtxt.ControlSource = DLookup("[TotalQuantity]", "[PrimaryRoadInventoryTotals]", "[PrimaryRoadInventoryTotals]![PrimaryRouteID] ='" & [Forms]![NavigationForm]![NavigationSubform].Form![PrimaryRouteIDtxt] & "'")

SqftSumtxt.ControlSource = DLookup("[TotalSqFt]", "[PrimaryRoadInventoryTotals]", "[PrimaryRoadInventoryTotals]![PrimaryRouteID] ='" & [Forms]![NavigationForm]![NavigationSubform].Form![PrimaryRouteIDtxt] & "'")
End Sub

```

One weird thing that I noticed, and what might be an indicator of what's wrong here, is that when I nest this code into a msgbox, it'll read "true" or "false." Don't know if that helps, but figured I'd mention it. 

I appreciate it!