Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2004
    Location
    Atlanta, GA
    Posts
    62

    Unanswered: Please look at this simple SQL ?

    SELECT PBI.pbiCname
    FROM PBI
    WHERE PBI.PBICCRNname = Forms!DONE!CCname;

    Ive got a form called "DONE" i'm pulling a value from a combo Called "CCname" and iv'e attached this querie to the rowsource of a list box on my form.
    If i change the "Forms!done!ccname" to the actual ccname "joe bloggs" i get a result, if i leave it the same "Forms!etc." i get no errors just a blank feild??
    I thought i had this figures out, is there something right in front of my face?
    Please help
    Brownie

  2. #2
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    is the form "Done" opened? Refreshed? Is there a me.refresh in the combo box's after update event?

  3. #3
    Join Date
    Sep 2004
    Location
    Atlanta, GA
    Posts
    62
    The form is open. I have a requery macro in the (ccname) combo box afterupdate event.
    Any ideas?

    Brownie

  4. #4
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    can you paste CCName combo's rowsource here?
    ghozy.

  5. #5
    Join Date
    Sep 2004
    Location
    Atlanta, GA
    Posts
    62
    SELECT ccnames.id, ccnames.CCnames
    FROM ccnames;

    This works fine and shows a list of names

  6. #6
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    I think the problem is when you say Forms!DONE!CCname you get the ccnames.id instead of ccnames.ccnames

    could you check ccnames combo's bound column value? it should be 2 according to your select statement.
    ghozy.

  7. #7
    Join Date
    Sep 2004
    Location
    Atlanta, GA
    Posts
    62
    Thanks for the reply Ghozy, i'll try it later

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •