Value in combo box is changed, all fields in the same form is updated

[DylaFadila]

Hi..i've problems with this update-combo box thigny..

I have a form (CD media details),then in the forms i have 4 types of combo box (CD_Location, Type, Category and Sub_category).
Other availble fields in the form i have Status, CD Title, Language, Date released, Part number, serial number and notes.

the issues here is that..when i click one of the combo box and choose any values..all of the fields in the form is updated/changing
For example, i go to CD_Location combo box n choose CD1-microsoft then the fields updated and shows all of "CD1-microsft" records..

[TheSmileyCoder]

Did you make the form yourself?
Whats the combobox's recordsource and controlsource?
Which events are tied to the combobox?

[DylaFadila]

yes.i make the form..
for the CD_Location combo box the record source comes from the table named "tblCDLocat ion" i extract the data from this table to make the lists.the control source is field combobox CD_Location itself in the current form.

events? what events..? i dont know how to use any events..it needs code right? im very weak in coding..

[DylaFadila]

actually i want it to be like this when i click one of the combo box and choose any values..all of the fields in the form is updated/changing..i dont know how to make it work this way..any suggestions?

[DylaFadila]

Did you make the form yourself?
Whats the combobox's recordsource and controlsource?
Which events are tied to the combobox?

-------------------------------------------------------
yes.i make the form..
for the CD_Location combo box the record source comes from the table named "tblCDLocat ion" i extract the data from this table to make the lists.the control source is field combobox CD_Location itself in the current form.

events? what events..? i dont know how to use any events..it needs code right? im very weak in coding..

actually i want it to be like this when i click one of the combo box and choose any values..all of the fields in the form will be updated/changing..i dont know how to make it work this way..any suggestions?