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

    Expand Collapse

    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?

  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 Aug 17, 2016
    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

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page