Display value from another form or table

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

Guest

I am creating a resume database, with tables for Candidates, Skills, and Status. There is also a corresponding form for each table. What I am trying to do is show a textbox on the Candidate form that displays this candidate's current status in our hiring process. Here is about 2 days of work; it is an expression I added to the "Control Source" item in the Properties for that textbox on the Candidate form. The piece of information I want to use resides on the Status table (and form)

=DLookUp("Status","Status",[CandidateID]=Forms![Status]![CandidateID]

This is the only expression that will not evaluate as a #Name error. It does not show the correct status though, it only shows the status that is the first record in the table. For example, the first record in the status table is "Tech" but the text box should display "New" but displays "Tech". CandidateID is set on the candidate table and is related to the field CandidateID on the Status table, but I do not know why it is not automatically carrying over from form to form. I am very new to Access so please bear with me. Any help is appreciated
Liz
 
Hi Liz,
Easy answer, you need to format your third paramter (
the "where" clause) like ...


=DLookUp("Status","Status","[CandidateID]= " & cstr(Forms!
[Status]![CandidateID]))

-----Original Message-----
I am creating a resume database, with tables for
Click to expand...
Candidates, Skills, and Status. There is also a
corresponding form for each table. What I am trying to do
is show a textbox on the Candidate form that displays this
candidate's current status in our hiring process. Here is
about 2 days of work; it is an expression I added to
the "Control Source" item in the Properties for that
textbox on the Candidate form. The piece of information I
want to use resides on the Status table (and form).
=DLookUp("Status","Status",[CandidateID]=Forms![Status]! [CandidateID])

This is the only expression that will not evaluate as a
Click to expand...
#Name error. It does not show the correct status though,
it only shows the status that is the first record in the
table. For example, the first record in the status table
is "Tech" but the text box should display "New" but
displays "Tech". CandidateID is set on the candidate table
and is related to the field CandidateID on the Status
table, but I do not know why it is not automatically
carrying over from form to form. I am very new to Access
so please bear with me. Any help is appreciated.
 
Back
Top