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 ...
11th July 2013, 10:52 PM #1
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?
IDG Tech News
12th July 2013, 12:48 PM #2
- Rep Power
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 12:57 PM.
12th July 2013, 03:07 PM #3
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.
By JB_IT in forum Web Development
Last Post: 4th May 2011, 11:51 AM
By mmoseley in forum Windows Server 2008 R2
Last Post: 10th March 2010, 10:14 AM
By My220x in forum Educational Software
Last Post: 8th March 2008, 09:19 AM
By Uraken in forum Coding
Last Post: 5th March 2008, 01:35 PM
By Halfmad in forum Wireless Networks
Last Post: 24th August 2007, 03:37 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)