Multiple form and nested Combobox

[ablaubla]

Hi all, I would really appreciate help as far as the nested comboboxes are concerned.
I can create a single form/subform/line with nested comboboxes, but I don't seem to get the way of how to do this in a multiple form/subform where I enter data... Do I have to open a new form for every single line?

I used the following code in the combobox:

SELECT [Fähigkeitdetail].[FD_ID], [Fähigkeitdetail].[Fähigkeitdetail] FROM Fähigkeitdetail WHERE ((Fähigkeitdetail.Fähigkeitname)=([Formulare]![BMS]![Navigationsunterformular]![Sub2]![SubFah]![Fähigkeitname]));

The SubFah is this multiple sub form where the attributes of a specific person appear and can be edited through combobox...[Fähigkeitname] is the first "column" where I get the value!

but this code somehow retrieves the value of the first line only!:banghead:
but there are multiple lines with comboboxes generated dynamically as I enter data...

anyone that can help?
BR abla

 

[Galaxiom]

Search for cascading comboboxes.

BTW It isn't recommended to use the same name for a field name as the table.

 

[ablaubla]

Hi,
thanks a lot,
I am using a german version at the office and I didn't know how they we're called in english and couldn't search it properly! I found some more threads will see if they can help me. As far as the names are concerned I didn't choose them Access did as it uses the wizard by default I found it time saving. Are you suggesting to change the names - they are causing the prob? even though as I see I must change my query a bit and somewhere enter an Inner join or sth....

 

[ablaubla]

One more thing, all the solutions provided are quite hard to create you need to add VBA code, even more querries, and "cover" the output of the combobox... is this the easiest way? I mean it's quite simple and logic with single forms but access can't handle cascading? after all the wizard creates the cascading forms...

 

[Galaxiom]

As far as the names are concerned I didn't choose them Access did as it uses the wizard by default I found it time saving. Are you suggesting to change the names - they are causing the prob? even though as I see I must change my query a bit and somewhere enter an Inner join or sth....

[Fähigkeitdetail].[Fähigkeitdetail] FROM Fähigkeitdetail

Access Wizard doesn't name the fields in the table.

Although it isn't specifically outlawed the use of the same name could cause some confusion particularly in queries written directly in SQL where the table names can often be dropped from the fieldname reference.

I also had an expereince once where Name AutoCorrect got confused when I accidentally renamed a table to the same name as a field in another table.

 

[ablaubla]

hmmmm, I see what you mean. It is likely that one of my problems is caused by this! Will check it and come back. thx! So better every table to have a different name and different fields? or is it ok if the fields have the same name? I normally use different names and fields but as I saw that Access allows it though there would be no prob! now I have to change the whole tables....:banghead:

 

[ablaubla]

Thanks Galaxiom, I found some other threads that helped me, I kept the names as they were and worked just fine!

 

[Galaxiom]

I didn't mean to indicate that the names were causing the problem. Simply that it isn't a good habit to get into.