Wrox Programmer Forums
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 15th, 2016, 02:08 PM
Registered User
Join Date: Mar 2016
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Lookup Form

Hello there,

These days I cannot solve issue which I am having with access.

The idea is to create a access form with checklist(drop-down-menu) and other values like firstname, lastname, friendlist(dropdownmenu) etc..
Here I want to create a possibility to search with form where I could find a customer on database which is equal to what I choose on form and other values which you click from dropdownmenu.

Example of form:

FriendList(Thomas,Jimmy,Henry,Martin) < valuelist(drowndownmenu) here I could check more than one value

I tried creating a query and on criteria writing :

Like "*" & [Forms]![SearchForm]![FirstName] & "*"
same criteria with Friendlist(drowndown) so it doesn't work this way and database are showing all possible results. I don't know anything about macros(vba).. Can someone help me please? I'm stuck with this project for some time and could find any answer how to complete this search form.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Use a form for both lookup and new data entry rmccafferty Access 3 September 17th, 2009 04:54 PM
lookup value in table Vince_421 Access 16 February 13th, 2007 08:15 AM
lookup value in tabel and store in continuous form Vince_421 Access VBA 1 May 22nd, 2006 09:22 AM
File name lookup acdsky Classic ASP Basics 3 November 22nd, 2003 11:49 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.