Ask Your Computer Question. Computer Experts Answer You ASAP.

(Not a Computer Question?)

Microsoft Access database form

Sent to Computer Experts December 9 2007 at 2:59 AM
   

I am working on a microsoft access form. Creating 3 cascading combo boxes on a form. Basically similar to example on http://www.fontstuff.com/access/acctut10.htm - example one- only this example shows only two cascading combo boxes.
I have tried some other examples using queries but - either don't work or don't feed data into main database.
I have not used this site before - so am not sure this is a relevant question here.
Can you help?
thank you

 

Optional Information:
OS: Windows XP; Browser: IE

Already Tried:
my form actually has more fields - and database is full of data- but now to help users out - they want me to make these combo boxes with drop down lists to help users input data easier and faster. the first combo box has a list of item numbers. when you select a number. the second combo box - ( a list of stores) should only show the store that item is located in. then in the third combo box ( a list of part descriptions) it should only show the list of parts pertaining to that particular store. thank you

Customer (name blocked for privacy)
Status:  Closed   Value: $10
Answer
December 9 2007 at 3:19 AM (20 minutes and 33 seconds later)
         
ACCEPTEDCheck Mark
Here's a quick example of a working quad cascading combo box. Hopefully this helps!

http://forums.devarticles.com/microsoft-access-development-49/cascading-multiple-combo-boxes-and-display-filtered-results-in-a-60986.html
Greg Nunemaker -- Computer Support Specialist -- 100% Positive Feedback on 5 Computer Accepts
10+ Years in the industry
Answer
December 9 2007 at 3:29 AM (9 minutes and 31 seconds later)
         
THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
Greg Nunemaker -- Computer Support Specialist -- 100% Positive Feedback on 5 Computer Accepts
10+ Years in the industry
Reply
December 9 2007 at 3:43 AM (14 minutes and 43 seconds later)
         
I am not sure this example is explaining enough for where I am at- starting with even the select statement with select distinct - I think I have had to go in to a query - into the query tab- then into sql specific- then I think data definition to have it recognize the ( distinct command) - but put that aside- I have tried examples like http://www.databasedev.co.uk/filter_combo_boxes.html- but they don't enter the data into my database for some reason- and form looks like it works - this example is explaining not enough about subform commands for me to figure it out.
any more ideas-
Thank you
Customer (name blocked for privacy)
Reply
December 9 2007 at 3:49 AM (5 minutes and 25 seconds later)
         
Thank you Greg,
hopefully this info at second link leads me to solution.
i am going to print it out and read it awhile before I start at this again.
my head at the moment feels like I walked into a low doorway.
thanks again
Customer (name blocked for privacy)
Answer
December 9 2007 at 3:54 AM (5 minutes and 30 seconds later)
         
THIS ANSWER IS LOCKED!
You can view this answer by clicking here to Register or Login and paying $3.
Greg Nunemaker -- Computer Support Specialist -- 100% Positive Feedback on 5 Computer Accepts
10+ Years in the industry
Reply
December 9 2007 at 4:07 AM (12 minutes and 59 seconds later)
         
I guess I am unclear in my communication so let me try to explain.
Originally, the examples I found online- I was unable to get the data from the form to enter into my main table- and I was using different sql statments- in the rowsource of each combo box- and I actually did get the forms to look like they were working
THEN
I came upon the example at http://fontstuff- just trying to get even two combo boxes to work together- and there first example worked and put data into the main table. Now I have not analyzed the difference of the code- but I know using a main table and seperate tables for each sub-category was easier to actually see how it was working. Then I realized I needed another combo box and I couldn't realy see how I could use this example to add another working combo box. So now I am hoping- with this example you showed me- I can solve this 3 combo problem.
Thank you
Customer (name blocked for privacy)
Think you can answer this question?
Login or Become an Expert

Related Answers

 

DISCLAIMER: You acknowledge that any information you may obtain from individuals you contact through use of the JustAnswer service comes from those individuals, not from JustAnswer, and that JustAnswer is not in any way responsible for any of the information these third parties may supply. The site and services are provided "as is" with no warranty and no representations are made regarding the qualification of an Expert. Responses and comments on JustAnswer are for general information and are not intended to substitute for informed professional advice (such as medical, legal, investment or accounting) and do not establish a professional-client relationship. JustAnswer is not intended or designed to address EMERGENCY QUESTIONS which should be directed immediately by telephone or in-person to qualified professionals. Please carefully read the Terms of Service.

JustAnswer > Computer Questions