combobox and subforums

[sasolini]

I need some help with combobox selecting data...

I create a table "parts", and a second table "language", and a nother table "names". Now i need a form with combobox for parts, under it i need data from "language" and then i need subform with "names".

Example:
Parts [Combomox]
Language1 [chackbox]
Language2 [chackbox]

Subforum:
Name1 , Name2 [textbox]

I create all that but i dont know how to make a combobox that will change data of "language" and "names" after selecting a part from the combobox. I guess i need a code afterupdate but i dont know what to write.

I hope i was cleare enough, elseway im sorry

Thx

 

[maxmangion]

if i understood your question correctly, you are looking for cascading combo boxes, so take a look at this thread , there is a good example on how to implement it.

However, i would suggest you to review your design again, because from the fieldnames which you mentioned in your example (language1, language2, name1, name 2), it seems that your data is not normalised at all ... thus you will end up with several problems as you go along.

Eventually, if you search this forum, there are several threads discussing normalization, which might give you a clear idea of what's all about.

 

[aleb]

Hmmmm.
I see that you need only two tables.
Parts (tbl1)
Partid
Partspec

Names (tbl2)
Nameid
PartidFK
LangSel
Description

On the form you also need an option group which will indicate the selection of Language.
Depending on the option selected the subform will display the names in whatever language you selected in option group and it is also will depend on the Main form "Parts" selection.

 

[usermj]

looking for cascading combo boxes, so take a look at this thread , there is a good example on how to implement it.

Thanks for the information.

I've been looking at that post.

The last paragraph which mentions how to keep the Parent combox react to any changes in child combox will be vital in this case.

in Parent Combox AfterUpdate event typing code: Me.cboChild.Requery.