Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

problem with lookup listbox in ms access 2003

Discussion in 'Information Technology' started by bkrasnof@gmail.com, Jul 28, 2006.

  1. bkrasnof@gmail.com

    bkrasnof@gmail.com
    Expand Collapse
    Guest

    Hi, I'm using an adp with sql 2005 express. I have a master-detail
    form and I want to show a customer name field from a different table
    using a foreign key lookup.

    I'm trying this for the rowsource:

    SELECT name
    FROM tblCustomers
    WHERE (pk_customerid = [Forms]![frmtblCustomerPO]![fk_customerid])

    but i'm getting syntax errors near the !

    Any ideas?

    thanks,
    Bruce
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikhs Face Problems While Carrying Kirpans In Khyber-Pakhtunkhwa - SikhSiyasat.Net Breaking News Jul 29, 2016
    "Dasam" Granth - A Look At The Core Problems Dasam Granth Oct 21, 2015
    Problems In Life Sikh Sikhi Sikhism Apr 13, 2015
    How can I make decent and useful friends and from where ?? most people have a problem with me Sikh Youth Oct 23, 2013
    The Problem with Taking Too Many Vitamins Health & Nutrition Oct 18, 2013

Share This Page