467,104 Members | 1,185 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,104 developers. It's quick & easy.

update a text box using combo box


Hi all,

I have 3 unbound combo boxes in my form which basically helps me to filter
for values. I need to update a text box which will be stored with the value
I receive after filtering with the combo boxes. I know of the column(n)
method (derived from the third combo). However if the user does any sort of
manipulation in the first or second combo then the value in the text box
doesn't change accordingly. Is there any other way to update the text box in
a more accurate way. Please help. TIA

--
Regards,
B


Nov 13 '05 #1
  • viewed: 1921
Share:
1 Reply
Burghew wrote:
Hi all,

I have 3 unbound combo boxes in my form which basically helps me to filter
for values. I need to update a text box which will be stored with the value
I receive after filtering with the combo boxes. I know of the column(n)
method (derived from the third combo). However if the user does any sort of
manipulation in the first or second combo then the value in the text box
doesn't change accordingly. Is there any other way to update the text box in
a more accurate way. Please help. TIA


In the AfterUpdate even of Combo1 enter something like
Me.Combo2.Requery
Me.Combo3.Requery
Me.txtbox = Me.Combo3.Column(2)

In the AfterUpdate even of Combo2 enter something like
Me.Combo3.Requery
Me.txtbox = Me.Combo3.Column(2)

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Pam Ammond | last post: by
6 posts views Thread by eclypz | last post: by
1 post views Thread by Rodney Frisard | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.