The wife asked me to capture our grocery shopping info, simple enough. Create a few tables, a Form and Report. Well, I am stumped. I may have designed it wrong and that is why I am having a problem. I have a few tables. One table has major grocery categories ( produce, meat etc. ). The second table is a sub class of the first table in that pork is a meat and apple is a fruit. Another table
added the types for table 2, i.e. Granny Smith is an apple, bacon is a type of pork which is under meat. I designed the Form with combo boxes so that I could create a record without a lot of keystrokes. The problem is, if I select grocery in the first combo box, I only want to see in the second combo box, items that are related to groceries. In the third box I only want to see items that are related to apples.
I tried to use queries as the data source but I am having some problems selecting the "previous/upper" combo box selection. I used a straight query and the results were displayed in a table, not the combo box. I then tried adding the DLookUp function to the query to select a sub set. Well the select works but returns zero results and it is in a table format.
I want to be able to use the selection made in the previous combo box as part of a filter to reduce the amount of data for the next combo box. I have been in and out the Access programming in the past few years. I am relegated to Access97. Had a system problem and Access2003 is missing some files and I cannot find the install CD. Not sure what info you need.
I have searched the Access forum but I could not see any way to sort within returned results to fine tune the search. Too many results to read in a life time
The problem is, if I select grocery in the first combo box, I only want to see in the second combo box, items that are related to groceries. In the third box I only want to see items that are related to apples.
Ok, so in the second combo box, you need to have the Row Source have a criteria that references the first combo box and so on. To do so you'd need a reference to something like: