create a look up
in [General]
|
From: JMD.Park on 12 Mar 2010 11:51 I would like to create a look up for a field in a form. I would like to put in a customer number that will bring up their name and address info. How can I do this? Thanks in advance for your assistance.
From: JMD.Park on 12 Mar 2010 12:08 "JMD.Park" wrote: > I would like to create a look up for a field in a form. I would like to put > in a customer number that will bring up their name and address info. I would like the address and info to come from a table in the same database. How can > I do this? Thanks in advance for your assistance.
From: fredg on 12 Mar 2010 12:13 On Fri, 12 Mar 2010 08:51:02 -0800, JMD.Park wrote: > I would like to create a look up for a field in a form. I would like to put > in a customer number that will bring up their name and address info. How can > I do this? Thanks in advance for your assistance. It depends. If The [CustomerNumber] field's datatype is a number, then: =DLookUp("[Address]","TableName","[CustomerNumber] = " & Me.[CustomerNumber]) However, if the [CustomerNumber] field is a Text datatype, then: =DLookUp("[Address]","TableName","[CustomerNumber] = '" & Me.[CustomerNumber] & "'") Do the same for the Customer's Name field. Change CustomerNumber to whatever the actual field name is. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
From: John W. Vinson on 12 Mar 2010 12:32 On Fri, 12 Mar 2010 08:51:02 -0800, JMD.Park <JMDPark(a)discussions.microsoft.com> wrote: >I would like to create a look up for a field in a form. I would like to put >in a customer number that will bring up their name and address info. How can >I do this? Thanks in advance for your assistance. Open the Toolbox; select the magic wand icon. Then select the Combo Box tool and put a combo box on the form. Use the wizard option "use this combo to find a record". -- John W. Vinson [MVP]
From: De Jager on 13 Mar 2010 12:22 "JMD.Park" <JMDPark(a)discussions.microsoft.com> wrote in message news:D3C7513D-1C79-4FDF-BD2A-7EE674841115(a)microsoft.com... >I would like to create a look up for a field in a form. I would like to put > in a customer number that will bring up their name and address info. How > can > I do this? Thanks in advance for your assistance.
|
Next
|
Last
Pages: 1 2 3 4 Prev: Subdatasheet records not updating totals Next: Crystal Reports 2008 |