is it possible to call a value from another table????

[Philip Mitchell]

does anybody know if it is possible to call a value from
another table??

I am trying to call a value already entered into a table,
the the table is called Technical_support_staff, the
value is called Unallocated - its primary key is called
N/A i have tried to enter the following code but it just
does not work can anyone help?

If Cleared_by_phone = True Then
Parts_required = "None"
Priority = "N/A"
Date_resolved = Date
Technical_Support_staff_email_address = "N/A"
Else:
If Cleared_by_phone = False Then
Parts_required = ""
Priority = ""
Date_resolved = ""
Technical_Support_staff_email_address = ""
End If
End If

 

[Bruce]

Hi,

try this:

Variable = Dlookup ("[name of field]", "[Table
name]", "condition")

E.g. Variable = Dlookup
("[Unallocated]", "[Technical_support_staff]", "[N/A] = 2")

let me know how you get on?

Bruce