I have a textbox (txtSalesNotActive) on a form (frmProfile_person_history_subform) that produces a person key. I then have another textbox (txtSales) that I want to display the person's name from a table (person) based on the person key in (txtSalesNotActive)

I currently have this as the DLookup Function in txtSales:

=DLookUp("[last_name]","[person]","[person_key] = '" & [Forms]![frmProfile_person_history_subform]![txtSalesNotActive] & "'")

Person Key is listed in the person table as the primary key. When the form loads, it just displays #Error in txtSales.

It sounds as if you are actually looking for information on a subform. You would need to reference it properly to get it to work.

First, you need to realize that you reference the subform CONTAINER (the control on the main form that houses the subform on the main form) and NOT the subform name itself (unless it is exactly the same as the subform container name, which it can be but isn't necessarily).

Second, you need to use the word FORM to tell Access you are referencing something on the subform and not the subform control.

So IF the code is on the main form you would refer to it like:

[YourSubformContainerNameHere]![Form]![txtSalesNotActive]

or if it is on a completely other form

[Forms]![YourMainFormNameHere]!
[YourSubformContainerNameHere]![Form]![txtSalesNotActive]

__________________
Thanks,

Bob Larson
Access MVP (2008-2010, 2011)
Free Access tutorials, samples, tools

Bob, Thank you for your reply. The txtSalesNotActive value that I need to lookup the name from is not on a subform, that is just how the naming is. frmProfile_person_history_subform is a pop-up from a link on frmProfile

If txtSalesNotActive and txtSales are both on the same subform, then

Me.txtSales = DLookUp("[last_name]", "[person]", "[person_key] = '" & Me.txtSalesNotActive & "'")

If txtSalesNotActive is on the subform as you say, but txtSales is on the main form (or parent), then

Me.txtSales = DLookUp("[last_name]", "[person]", "[person_key] = '" & Me.frmProfile_person_history_subform.Form.txtSales NotActive & "'")

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division