+ Post New Thread
Results 1 to 3 of 3
Office Software Thread, Access - Query Drop Down Boxes in Technical; Need some help here, I have a database I have created and quite well on with but have a few ...
  1. #1

    Join Date
    Oct 2008
    Location
    Lincolnshire
    Posts
    2,196
    Thank Post
    13
    Thanked 228 Times in 217 Posts
    Rep Power
    67

    Access - Query Drop Down Boxes

    Need some help here, I have a database I have created and quite well on with but have a few issues I want to get round if I can.

    I want to be able to select model and it then in the next column display all the models associated with that make, how?

    Similar if I pick an area I want it to bring up up locations under that same as above.

    Also is it easy to create a validation rule on one field to check the string I enter is correct?

  2. #2

    Join Date
    Feb 2013
    Location
    North Lincolnshire
    Posts
    10
    Thank Post
    5
    Thanked 1 Time in 1 Post
    Rep Power
    0
    I assume you are going to be doing this through a form and storing the make id in the models table?

    If so, write a separate select query for your models drop down where the criteria for make_id is the id number stored in the "make" drop down field of your form. For example your criteria could be: Forms!Form_Name!Make_dropdown_name. Then just create a drop down box based on this new query for your models.

    You would then use this same scenario for your locations and areas.

    That's the way I am doing it at the moment for a job system I am building, somebody may know a better way though.
    Last edited by rs513; 12th July 2013 at 11:57 AM.

  3. #3

    Join Date
    Oct 2008
    Location
    Lincolnshire
    Posts
    2,196
    Thank Post
    13
    Thanked 228 Times in 217 Posts
    Rep Power
    67
    I will have a look. At the minute I just use a table view to do it, if I can get away without using a form to enter it I will but I can get round that.

    Will be back if it doesn't work.

SHARE:
+ Post New Thread

Similar Threads

  1. [AJAX] Dynamic drop-down boxes
    By JB_IT in forum Web Development
    Replies: 1
    Last Post: 4th May 2011, 10:51 AM
  2. Drop down box reveals networked computers
    By mmoseley in forum Windows Server 2008 R2
    Replies: 0
    Last Post: 10th March 2010, 09:14 AM
  3. Open Office Calc - Drop Down Selections
    By My220x in forum Educational Software
    Replies: 3
    Last Post: 8th March 2008, 08:19 AM
  4. drop down list in a html webform and php
    By Uraken in forum Coding
    Replies: 17
    Last Post: 5th March 2008, 12:35 PM
  5. 3COM Wireless access points - dropping network constantly
    By Halfmad in forum Wireless Networks
    Replies: 4
    Last Post: 24th August 2007, 02:37 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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