Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    dcwang3 is offline Novice
    Windows XP Access 2007
    Join Date
    May 2009
    Posts
    12
    question though:



    I am trying to add a drop down list in addition to the two search fields. Since I have the search fields working, I would like to specify it even further with a drop down list.

    I have another table that lists all the possible assemblies that you can choose from. How would I type use an expression builder to build a code for the criteria?

    Would it be the same as this:

    Like!forms!<what form>.<what the name of the combo box>&"*"


    Thanks

  2. #17
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The ! after LIKE should be a space.

  3. #18
    dcwang3 is offline Novice
    Windows XP Access 2007
    Join Date
    May 2009
    Posts
    12
    I know, it should automatically format it...but I am saying, should it be similiar to that format when you are using a drop down list, or would it be different?

    Because part of me says it may be different because the particular entry is there listed in the drop down list, rather than having to type in the full name or part of the it

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Beginner trying to send email with attachment
    By ahm in forum Programming
    Replies: 2
    Last Post: 03-24-2009, 08:51 PM
  2. 1st Access application. Needs a clue..
    By Icedog in forum Access
    Replies: 3
    Last Post: 09-24-2008, 09:38 AM
  3. Replies: 0
    Last Post: 08-26-2008, 09:22 AM
  4. Access application to Web based application
    By admaldo in forum Access
    Replies: 0
    Last Post: 06-12-2008, 06:22 AM
  5. Modifying and existing MS Access Application
    By bjohnson in forum Access
    Replies: 2
    Last Post: 03-08-2006, 07:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums