Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2004
    Posts
    277

    Unanswered: Value of a List box

    I am sure there is a simple solution for this but I can't think for nothin right now....

    the information shown in a list box for example reference# 48000,48001,48006 (which change all the time so another time could be 49015,49945,49999)

    I want to open a form with a WHERE clause to open the form based on the reference# showing all info concerning that reference#.

    I would rather it be based on the OnClick of the listbox but it could be off of a command button... please help

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    where's the problem?

    if your wannabe form is based on a query (if not: fix it) open the query in design view, hit the criteria cell under the reference field and then hit the magic-wand thingie in the menu bar.

    in the resulting dialog:
    left-pane: navigate - forms/all forms/form with the list
    then middle-pane: double-click the name of your list.
    done

    ...unless this is a multiselect list: that's also very do-able but takes a little more effort.


    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Dec 2004
    Posts
    277
    the list value is coming up based on the position of the click...

    for example

    0,1,2,3...

    instead of pulling up the reference#

    besides I, am trying to learn the WHERE clause because I keep trying to use it but it does not seem to work for me.

  4. #4
    Join Date
    Mar 2004
    Posts
    7
    Have a look at this example...it's a Search Db that utilizes the Where clause function in Vb and passes it to a query or to a form...

    HTH
    Attached Files Attached Files

  5. #5
    Join Date
    Sep 2004
    Location
    Tampa, FL
    Posts
    520
    Change the column the list is bound to.
    In the properties the bound property dictates which column the query is looking at.
    Darasen

Posting Permissions

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