Combox box on Dataset and it needs to be seperate for different records in it

[Senthil]

Hello,

Hi Guys i am new to this forum and looking forward to contribute and also get help.

For now i have a Query and would like that to be sorted soon if thats possible as my deadline has almost been crossed.

Ok let me get to the point now.

1) I have a created access database.
2) I have created a datasheet form (frmSetRules) a table....
3) This form has a number of records in a datasheet and has three combo boxes at end
4) So i change the values of second combo box when a particular value is changed in first combo box
5) like wise i will change the combo box value of 3rd one depending upon the second combo box
6) I have coded to requery using the event after update for both first and second combo box.
now i will get to the problem i have or the part i dunno what to do
7) But since it is a datasheet, i have many records when i change the item in second record the first records second combox (sub category 1 flushes out and becomes empty)
8) I want the requrey macro embedded code in after update event to me just for the particular row and reflect for records

Is this possible in MS access 2010?

It is urgent so Please if you could provide me solution ASAP.

Thanks in advance!!!
ger size access files, so copied the screen dumb of the datasheet form for you guys

Sorry couldnt copy the access file as the site doesnt allow big
Thanks


Senthil

[CJ_London]

see this link which has an example of what you are trying to do for a datasheet

http://www.access-programmers.co.uk/...d.php?t=275155