Re: Help with syntax for passing a field value to a lookup query?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thank you. Now I understand what is happening.

Keith

"Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxx> wrote in message
news:uvx%23mUeJGHA.1192@xxxxxxxxxxxxxxxxxxxxxxx
>I trust you are not attempting to create lookup fields in a table design.
>For information on "why", check
>http://www.mvps.org/access/lookupfields.htm.
>
> You can and should use lookups (combo boxes) on forms. If you want to find
> out how to cascade your combo boxes on a form, check this link on Roger
> Carlson's web site
> http://www.rogersaccesslibrary.com/TableOfContents3.asp#C.
>
> --
> Duane Hookom
> MS Access MVP
> --
>
> "keithb" <kbrickey@xxxxxxxxxxxxxx> wrote in message
> news:%23UfLMHWJGHA.2212@xxxxxxxxxxxxxxxxxxxxxxx
>>I am trying define a lookup field in a table where the values displayed
>>depend on the content of an adjacent field.
>> For example:
>>
>> Lookup Table:
>> State-------City
>> AZ--------Phoenix
>> AZ--------Tempe
>> CA--------Los angeles
>> CA--------San Francisco
>>
>> If the state field in the primary table contains AZ, I want the lookup
>> combo box to display only Phoenix and Tempe...
>>
>> What is the correct syntax for passing a value from a field in the
>> primary table to a lookup query? When I use "[table].[field]" I get a
>> prompt for a value when the table is opened. When I use "table![field]",
>> the lookup combo box contains no entries.
>>
>> I used to know how to do this, but I forgot..
>>
>> Thanks,
>>
>> Keith
>>
>
>


.

Relevant Pages

  • Re: How does autofilled form fields info end up in table fields?
    ... Combo boxes in Access can display multiple columns when dropped down. ... Select the lookup field. ... I even tried datasheet style form, ...
    (microsoft.public.access.formscoding)
  • Re: WordMerge97
    ... So, really, it depends on how many names you have to display. ... display 5000 names in a listbox, and have the user plow throw that many ... application if they don't have a way to find, and lookup a name now). ... You would ONLY want to check the boxes AFTER ...
    (microsoft.public.access.forms)
  • Re: LOCATE vs. LOOKUP
    ... Keith G Hicks wrote: ... > For example in areas where I have a data set in a data module and use ... > it to lookup information sometimes. ...
    (borland.public.delphi.database.ado)
  • Re: Help with syntax for passing a field value to a lookup query?
    ... You can and should use lookups (combo boxes) on forms. ... out how to cascade your combo boxes on a form, ... >I am trying define a lookup field in a table where the values displayed ... > combo box to display only Phoenix and Tempe... ...
    (microsoft.public.access.tablesdbdesign)
  • lookups
    ... I am trying to use a lookup ... statements that copies values out of one spread sheet over ... I have to do a special paste ... Keith ...
    (microsoft.public.excel.worksheet.functions)