Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    query ? (Access 97 )

    I have a table called userprojects with 2 fields user and project. I know if I make a parameter query with a criteria of [enter user] under the user field it will ask me the enter a user. The result will show me all the projects for the user name I typed in. The problem is this has to be typed in exactly or the query will fail. Is there any way I can do this with a drop down selection box on a form or in a query? Any help is appreciated. Thanks..

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: query ? (Access 97 )

    Yes there is a way, as you suggest, use a combo box of User Names. Then just use that in the query.
    Assuming you form was called frmMainForm and your combo box was called cboUserName then under criteria in the query for UserName just type:

    Forms![frmMainForm]!cboUserName

    This will then get its user name from the forms combo box.
    HTH
    Pat

Posting Permissions

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