Results 1 to 2 of 2
  1. #1
    bigmac is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2008
    Posts
    21

    Question lookup wizard

    hi, i have made two different data bases both on access 2010, and in both i have lookup fields , but in one when i click the lookup field objects are in boxes and it has a ok, cancel in the bottom, the other is just like a combo box all i have to do is click on what i want in the field and its there straight away, i want the second to act like the first how do i do that please

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,847
    As a general approach, don't have Lookups at the Table.

    http://access.mvps.org/access/lookupfields.htm

    Use a separate table and join the tables as required.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Lookup Wizard Question
    By Marisha in forum Access
    Replies: 6
    Last Post: 10-27-2011, 12:54 PM
  2. Lookup Wizard Problem
    By Boltman in forum Access
    Replies: 2
    Last Post: 07-31-2011, 10:06 PM
  3. Lookup wizard
    By VLI in forum Forms
    Replies: 7
    Last Post: 01-28-2011, 09:25 AM
  4. Lookup Wizard and Multivalued columns
    By haygun in forum Access
    Replies: 0
    Last Post: 01-27-2010, 11:04 AM
  5. Using tbale field in Lookup Wizard
    By dotancohen in forum Database Design
    Replies: 5
    Last Post: 12-10-2009, 02:54 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