DLookUp is driving me crazy.

[Guest]

I have a form [f_Request_List], which contains a box [UrgencyID_Box] that is
a numerical value, just on it's own it display a result number just fine. The
lookup table [t_Urgency] contains two fields, [t_Urgency] (text) and
[UrgencyID] (numeric), there's only 3 records.

The following Yields #Error
=DLookUp("[Urgency]","[t_Urgency]","[UrgencyID]='" & [UrgencyID_Box] & "'")
=DLookUp("[t_Urgency]![Urgency]","[t_Urgency]","[UrgencyID]='" &
[UrgencyID_Box] & "'")

The following causes the text span across the fields when the form is
displayed and locking the .ldb. file forcing a reboot to clear the memory.
The same thing happens when I use the various incarnations of 'Me!'.
=DLookUp("[Urgency]","[t_Urgency]","[UrgencyID]='" &
[Forms]![f_Request_List]![UrgencyID_Box] & "'")

I've read about not putting spaces in, however Access is doing this on its
own.

 

[Ken Snell [MVP]]

If UrgencyID is a numeric field in the table t_Urgency:


=DLookUp("Urgency","t_Urgency","[UrgencyID]=" & [UrgencyID_Box])

 

[Guest]

Ken~

Most helpful, I was using the format for text, not numbers. Also I had to
hide the UrgencyID box, and use a 2nd box to display the result.

Live and Learn
THANKS!
~Lori

If UrgencyID is a numeric field in the table t_Urgency:


=DLookUp("Urgency","t_Urgency","[UrgencyID]=" & [UrgencyID_Box])


--

Ken Snell
<MS ACCESS MVP>

I have a form [f_Request_List], which contains a box [UrgencyID_Box] that
is
a numerical value, just on it's own it display a result number just fine.
The
lookup table [t_Urgency] contains two fields, [t_Urgency] (text) and
[UrgencyID] (numeric), there's only 3 records.

The following Yields #Error
=DLookUp("[Urgency]","[t_Urgency]","[UrgencyID]='" & [UrgencyID_Box] &
"'")
=DLookUp("[t_Urgency]![Urgency]","[t_Urgency]","[UrgencyID]='" &
[UrgencyID_Box] & "'")

The following causes the text span across the fields when the form is
displayed and locking the .ldb. file forcing a reboot to clear the memory.
The same thing happens when I use the various incarnations of 'Me!'.
=DLookUp("[Urgency]","[t_Urgency]","[UrgencyID]='" &
[Forms]![f_Request_List]![UrgencyID_Box] & "'")

I've read about not putting spaces in, however Access is doing this on its
own.