You want an SQL statement like this
Select CustName from TableName where Calleranme =' & sCallerName & "'"
Make this your record source for your DB
----- Original Message -----
From: "John Anthony" <janthony@s...>
To: "VBA_Access" <vba_access@p...>
Sent: Saturday, July 21, 2001 2:45 PM
Subject: [vba_access] Lookup Table for field on form
> Can anyone send me the steps and possbibly the code what I need to do to
> get the following to happen.
> I have a form (help desk type form), where I enter the customer name (from
> a look up) and then Enter the Caller's Name (from a look up). What I want
> to happen is to limit the list of Caller's Names that have are available
> in the lookup form to only those callers from that particular customer.
> The table for Caller's Names is related to the Customer Table by the
> customer number. So I know there has to be a way to do this.
> Please help.