Results 1 to 5 of 5
  1. #1
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664

    Creating drop down menu in a Form

    In the Lesson 22 tutorial presented here:



    http://www.functionx.com/access/Lesson22.htm

    They create form where the called Countries toward the end where:

    The have a textbox for Government Type. It is a drop down menu of choices
    that the database creator can choose such a capitalist, socialist, and communist etc.

    However, in the form (with the records source as Countries) there is only a
    space for input no drop down menu. I know this may seem awful elementary to the
    seasoned database designer, but how does one get it to be a drop down menu?

    I have made the input in Countries table to be a look-up which I typed (see above choices)
    and the is the control source for the Countries Form government type. But there is still no
    drop down menu with choices on the Countries form.

    What must I do additionally?

    If this is already talked about in one of the MS Access 2010 tutorials earlier lessons then a referral to that
    source is all that is needed.


    Any help appreciated. Thanks in advance.


    Respectfully,


    Lou_Reed
    Last edited by June7; 08-06-2015 at 02:09 PM. Reason: correct title

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    A 'dropdown' is a combobox control.

    The form shows a combobox for GovernmentType - not a textbox.

    Did you build lookup in table after building the form? That will not change the form design.

    Delete the textbox and now drag the field from the form design Field List. This should create combobox.

    I NEVER build lookups in table. I manually build comboboxes on forms.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    I am not sure as to what is the difference: 1. building lookups in a table; 2. building lookups in a form.
    I understand from your post that you prefer the latter.

    Respectfully,


    Lou_Reed

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    I prefer to see actual values in table. A lookup field with an alias does not allow that.

    Did you get the combobox on form?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Lou_Reed is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2015
    Posts
    1,664
    Yes, I got it on the form. Everything is fine. I just could not understand why
    it could not gone on the table.

    Respectfully,


    Lou_Reed

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

Similar Threads

  1. Alphabetical Drop Down Menu
    By OzGrant in forum Access
    Replies: 1
    Last Post: 03-15-2015, 02:58 AM
  2. Drop Down Help Menu
    By dandoescode in forum Access
    Replies: 1
    Last Post: 08-07-2012, 02:51 AM
  3. Drop down menu help
    By whojstall11 in forum Access
    Replies: 6
    Last Post: 03-07-2012, 01:51 PM
  4. Replies: 3
    Last Post: 11-29-2011, 07:01 AM
  5. How about creating a drop down menu in a report?
    By beastmaster in forum Access
    Replies: 2
    Last Post: 12-29-2005, 01:01 PM

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