Access 2007 Sub Field

PCRIDE

Well-known Member
Joined
Jan 20, 2008
Messages
902
I have a form and I want a sub field to display certain content or choices based on the first field choice.

Example

Field 1 would have several categories (Fruit, Vegies, Meat, Chicken etc)
Field 2 would have the names of the category chosen

Fruit--> Apples, Orange, Bannanna
Vegies--> Squash, potato etc...

Any leads or Tutorials out there?

Thanks,
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Do a search on the Board for Cascading combo -- there are plenty of examples. Also, think about the structure. If the second field is one to one with the first (eg, pick a Category and NEVER more than one member), you can keep the second field in the same table. If you will have multiple items, you need a related table that will let you add one record per item.
Access 2007 does have multi-value fields (to make it compatible with some of the list features in Sharepoint) but this feature is not compatible with earlier versions of Access.

Denis
 
Upvote 0
I found a video tutorial and I am stuck at the section at 1:55 on the video.

Basically I have my 2 tables and created a query for the Sub-option. In the Query under filter I am unclear on what the follow is referring to.

Please advise.

[FORMS]![CustomerF]![StateCombo]

Is the FORMS tell the query to look at the FORM called "CustomerF" and the Field "StateCombo"

??

Heres the video
http://www.599cd.com/tips/access/two-combo-boxes/
 
Upvote 0
You have hit it on the head. If your form has a different name, then you must put your form name in for [CustomerF] and your field name that houses the combo box for the stateCombo field. The formula shown is placed in the criteria section of the query.

Here is another tutorial that shows a slightly different method.

http://www.fontstuff.com/access/acctut10.htm

Good Luck

Alan
 
Upvote 0
Ok, I am still on the first one an almost have it. But its still not working.

This is what I have.

IF this matters I have created an Excel Sheet with the Selections in Combo1 and Combo2 for the ease of the user updating the fields and the sheets feed the combo boxes.

I then connected the sheets to 2 tables one for Combo1 and Combo2

Combo 2 table has the categories and sub categories like in the video (State-->City)

When I select Combo1, Combo2 populates the State Category, not the corralating Sub Categories or (Cities) in the example. Its like access is looking at the wrong column.

Please advise.
 
Upvote 0
I was able to get it finally. HOWEVER....

The table that pulls the values for Combo box1 is pulling the value, when I select the option I get a pop up to run the query, If I retype the exact same text in Combo box 1, then Combo box 2 populates.

Its like the text format or something is not the exact same.

Got any ideas?
 
Upvote 0

Forum statistics

Threads
1,213,532
Messages
6,114,176
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top