DLookup (populating text based on other selections on form)

Hi All,

I have searched a few posts and still having trouble with this easy
(hopefully) fix.

I have a form called "Form_Update_Individual_Goal". On this form are a few
combo boxes (Quarter, Year, VP Name, Director Name, Manager Name, Associates
Name and Goal). Each of these are based on a table called
"Individual_Goals_Input: All Items". On this table is the above combo boxes
plus a field I want to bring down to a text box called "Measure"

So Ideally, what i want to do is the following:
Person Selects on form:
Quarter: Q1
Year: 2010
VP Name: Happy
Director Name: Orange
Manager Name: Alpha
Associates Name: Joe Blow
Goal: Do Something Good

and based on those selections above on measure should populate on a text box
that is read only -"You have to do something good for 20 people in 1 year"


So I have two things going so far:
1) When goal is selected, an event is happening after update:

Private Sub Goal_AfterUpdate()
Me.Measure.Requery
End Sub

2( this may be the problem)) - On the measure text box (the box i want to
populate "You have to do something good for 20 people in 1 year"):
=DLookUp("[Measure]","[Individual_Goals_Input: All Items]","
[Individual_Goals_Input: All Items]!Goal"="Forms!Form_Update_Individual_Goal!
Goal") in the control source

And nothing is happening.

What Am I missing (probably everything)? Hopefully something easy

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/201005/1