Error

[Perfac]

Dlookup("BudgetAmount114","q09BudgetAmounts","CmbEnt_ID114=" & BudgetItem _ & " And MonthNumInBus114a <= " & MonthNumInBus038 _ & " And MonthNumInBus114b >= " & MonthNumInBus038)

The expression you entered contains invalid syntax. All items in red is in the foreign object. The ones in blue is in the local object.

[Micron]

Nothing painfully obvious without seeing whatever is behind this expression, but if the blue parts are form/report controls, try wrapping in brackets [ ] especially since the underscore might be interpreted as a line continuation character. I'm also not sure about the use of multiple comparison operators such as >=. I'd also try just one or the other to see if it matters because I think I came across this before but can't recall the outcome.

[davegri]

If that code is all on one line, remove the blue underscores.
If you want it on multiple lines, leave the blue underscores but place the cursor on the right of the blue underscores and hit ENTER (2 places).

[Micron]

You're probably right. I took them to be part of the names.