Expressions to populate one field based on combobox selection.

[IncidentalProgrammer]

I'm still having some troubles with my insurance claim entry form. I have a couple of comboboxes where users select the Account and then the Policy Number, and based on the policy they choose in that box, I have 5 text boxes that need to display some data about the policy. The text boxes are unbound because the data doesn't need to be changed on the table its coming from, or sent anywhere else because it would just be duplicate; these are just here for users to help verify that they're setting the claim up on the correct policy.

The problem I'm running into is expression syntax. Right now, I'm trying to get the insurance company's name to populate in one text box, based on the policy number the user selects. It has to jump through some hoops to get it though, and that's where I'm messing up. Basically, it goes like this:
The Company text box needs to display the Company Name found in the Entity table where the EntityID on that table matches the CompanyEntityID on the Policy table where the Policy Number matches what the user selected in the combo box.



I'm then going to have to do pretty much the same thing with the policy type, status, and term (2 date fields) boxes.

Does anyone know the syntax for that, or where to find some good examples? I tried the example on Microsoft's site, but that made the box flash #ERROR.

[IncidentalProgrammer]

I tried creating a query to get the information I need from those two tables, and route the expression through that. I ened up with this:

=DLookUp("[EntPrimName]","qryMnlClaim","[PolNum] =" & [Forms]![frmClmAdd2]![ctlPolNum])

But it's still not working. Anyone see where I'm going wrong?