Limit Dropdown List

[EnergyTed]

I have two fields in a form (Ms Access). These are prepopulated from linked tables.

Field 1: [Element], example - A1, A2, B1, B2, C1, etc

Field 2: [Sub Element], example - A1.1, A1.2, A1.3, B1.1, B1.2, B1.3, etc

Once A1 has been selected for [Element], I would like to limit the dropdown for [Sub Element] to only, A1.1, A1.2, etc].

I have tried some If ElseIf statements on the On Enter procedure but am struggling. Can someone please advise, or point me in the right direction.

Kind Regards

 

[Remou]

There are several FAQs and numerous post on this topic. For example:
Combo Box - dependant on another Combo Box
faq702-4289

 

[EnergyTed]

Can you provide me with any other posts for this topic as FAQ702-4289 is not quite what I am looking for ?

 

[Remou]

Have you tried Advance Search?

 

[EnergyTed]

Yes, and am not getting anywhere

Can you please advise ?

 

[SgtJarrow]

How did FAQ702-4289 not meet your needs???

From your description you have two combo boxes. The first has elements A1, A2, etc. The second has subelements of the elements A1.1, A1.2, etc.

When you select the A1 in the first box, you only want the A1 items in the second.

The FAQ listed above does EXACTLY that. Why did it not work? What did you try? Can you post the sources for the comboboxes so we can see why it did not work?

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[terre]

Take a look at this, I found it easy to do, and understand.

http://www.mvps.org/access/forms/frm0028.htm