DLookup - Headscratcher (Circular Reference)

[iDeals]

Okay, so I have the following subform (fsubExpense) setup as follows:

Source Object: fsubExpense
Link Master Field: ProjectID
Link Child Field: fkProjExpProjID

Form Properties:

Record Source: tblExpenses

txt box control Source:

=DLookUp([WE Record],"FeeStructure","fkFeeOriginatorID=" & [Forms]![frmProjects]![fkProjOriginatorID])

DLookup is giving a circular reference. Ideas? Need more info?

[pbaldy]

For starters, all 3 arguments are strings (need to be in quotes).

[iDeals]

LOL I promise I tried it both ways... where is the emoji hitting their head against the wall when you need it. The quotes fixed it. DOH

[pbaldy]

Happy to help!