Need to populate a text box with query results ...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to populate a text box with output from a query without
having to redo the form.

I would like to display the department name
in the form. In the control source for this text field I entered something
like -

"=(select Department!Dept_Name from Department where
Department.Dept_code=[RequestingDept])"

I don't get the desired results. What am I doing wrong? Or is there any
better way to achieve this? The [RequestingDept] is one of the fields on this
form which contains the department code and maps to the linkded department
table.

Thank you,
-Me
 
Hi Me

Use DLookup instead

= Dlookup("Dept_Name","Department","Dept_code= " & [RequestingDept])

If the Dept_code field type is text, the use this
= Dlookup("Dept_Name","Department","Dept_code= '" & [RequestingDept] & "'")
 
Hi Ofer,

Thank you very much!
-Me

Ofer said:
Hi Me

Use DLookup instead

= Dlookup("Dept_Name","Department","Dept_code= " & [RequestingDept])

If the Dept_code field type is text, the use this
= Dlookup("Dept_Name","Department","Dept_code= '" & [RequestingDept] & "'")

--
\\// Live Long and Prosper \\//
BS"D


Me said:
I want to populate a text box with output from a query without
having to redo the form.

I would like to display the department name
in the form. In the control source for this text field I entered something
like -

"=(select Department!Dept_Name from Department where
Department.Dept_code=[RequestingDept])"

I don't get the desired results. What am I doing wrong? Or is there any
better way to achieve this? The [RequestingDept] is one of the fields on this
form which contains the department code and maps to the linkded department
table.

Thank you,
-Me
Click to expand...
Click to expand...
 
Back
Top