Hi,

I got around my previous problem by a trial-and-error method. Now
only one problem exists. If it is also rectified, I will be on my
way. :)

I told you that I am using a subform on my main form. I have a
control which holds a value and a combo box on the subform which
displays a list based on the value on the main form (which I
mentioned above).

Now I can get the value from my subform. But the problem is that, how
will I know if a change is made to the control on the main form. I
figured that I can requery the combo box control each time it gets
focus. But whatever I tried, the combo box doesnt respond to
onGotFocus, onEnter methods.

How can I trigger these methods ? Any ideas

TIA
Rajesh

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

The methods you are using are as the combo box gains focus, so it will not 
have changed, try the onChange event or the Click event.

> Hi,

I got around my previous problem by a trial-and-error method. Now
only one problem exists. If it is also rectified, I will be on my
way. :)

I told you that I am using a subform on my main form. I have a
control which holds a value and a combo box on the subform which
displays a list based on the value on the main form (which I
mentioned above).

Now I can get the value from my subform. But the problem is that, how
will I know if a change is made to the control on the main form. I
figured that I can requery the combo box control each time it gets
focus. But whatever I tried, the combo box doesnt respond to
onGotFocus, onEnter methods.

How can I trigger these methods ? Any ideas

TIA
Rajesh

__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com