D
Duane
I am trying to obtain the value of a field that is not in the current record
on my form. I was hoping to use the DLookup function to get the value I
need, but it is not working correctly.
I have a form called PrisonerData with the following controls:
text field - PNumber
text field - Race
I have a link to another table in a different db that is called Prisoners.
The keyed filed in the table is the Number field, which has the same values
as the control PNumber that is on my form.
The control source in the Race field on the form:
=DLookUp("[Race]","Prisoners","[PNumber] =" &
[Forms]![PrisonerData]![PNumber])
I am only receiving the value in the RACE field of the prisoners table which
is in the first record. In this case it is WH. In this scenario, there are
WH & NW.
I am hoping someone can give me a hand. Maybe I can't go about it this way,
and if so, can someone give me an idea for another method?
Thanks
on my form. I was hoping to use the DLookup function to get the value I
need, but it is not working correctly.
I have a form called PrisonerData with the following controls:
text field - PNumber
text field - Race
I have a link to another table in a different db that is called Prisoners.
The keyed filed in the table is the Number field, which has the same values
as the control PNumber that is on my form.
The control source in the Race field on the form:
=DLookUp("[Race]","Prisoners","[PNumber] =" &
[Forms]![PrisonerData]![PNumber])
I am only receiving the value in the RACE field of the prisoners table which
is in the first record. In this case it is WH. In this scenario, there are
WH & NW.
I am hoping someone can give me a hand. Maybe I can't go about it this way,
and if so, can someone give me an idea for another method?
Thanks