Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004

    Unanswered: Help with list box.

    Hey guys I am trying to create a form where I put all a persons information.
    The problem I am having is I am trying to make drop down boxes for certain fields like Sex, Race, Hair Style, Hair Length, Hair Color etc. Isnt there a easy way to do this. I thought there was a way where you just edited a line in the text box properties, like "Male","Female"

    Attached Thumbnails Attached Thumbnails fir.jpg  

  2. #2
    Join Date
    Mar 2004
    Nashville, TN
    What you are wanting to do is use a lookup field that is linked to a table with the different information.

    Have you used lookup fields before? Its pretty easy... you can just follow the wizard. Let me know how you turn out.

    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting by Patriot Designs

  3. #3
    Join Date
    Nov 2003
    Yes there is and here is how you can modify your form. As a sample we will do the Sex TextBox field.

    1) Place the form into Design view.
    2) Click on the Sex TextBox so it is highlighted with the sizing control.
    3) From the main menu, select Format | Change To | Combo Box.
    4) Open the properties wiindow for the now ComboBox Control.
    5) Select the Data tab in the propties window.
    6) Locate the Row Source Type property and change it to Value List.
    7) In the Row Source property enter: "Male";"Female";"Both"
    8) Make sure the Bound Column property is set to 1.
    9) Now select the Format tab in the properties window.
    10) Make sure the Column Count property is set to 1

    Save and Run your Database.

    There ya go.

Posting Permissions

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