I have two tables. One table holds parameters (T_Parameters). On this table, it has the MIN and MAX. In another table, holds the test that was completed (T_Rate). I then created a form that is for the T_Rate. In it, there is the "description" of the material being tested as entered for the T_Rate. I want to pull in the parameters into the form header. I dropped a text box and entered
=DLookUp("[Target_Window_MIN]","[T_Parameters]","[Description]=" & [Forms]![T_Rate]![Description])
I have done this before, and I cant seam to get this one to work. Im stuck and I didn't expect this to take some much time, since I've seen other examples.