p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

vba_access thread: Lookup Table for field on form


Message #1 by "John Anthony" <janthony@s...> on Sat, 21 Jul 2001 14:45:51
John,
  You want an SQL statement like this
    Select CustName from TableName where Calleranme =' & sCallerName & "'"

Make this your record source for your DB
Mike Wilson

----- 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.
>
> John
>


  Return to Index