By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,477 Members | 1,641 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,477 IT Pros & Developers. It's quick & easy.

Field Refresh

P: n/a
jen
I have two combo boxes, Field A and Field B.

When I select am item in Field A, Field B updates, dependant on Field
A. I have this working correctly, however, I'm getting stuck on the
display of Field B. For example, I select Apples from Field A, and
then choose Red in Field B. Then I change my mind and want to select
Oranges in Field A, so I do so. When I select the dropdown in Field B,
Orange is there, yet Red is showing in the Combo Box itself.

Is there any way to refresh this so my user can't select Red Oranges?
Thanks in Advance!

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"jen" <je*******@gmail.com> wrote:
When I select am item in Field A, Field B updates, dependant on Field
A. I have this working correctly, however, I'm getting stuck on the
display of Field B. For example, I select Apples from Field A, and
then choose Red in Field B. Then I change my mind and want to select
Oranges in Field A, so I do so. When I select the dropdown in Field B,
Orange is there, yet Red is showing in the Combo Box itself.

Is there any way to refresh this so my user can't select Red Oranges?


You could have some code in the first combo box's On Change event which
sets the contents of the second to a zero-length string, something like:

Private Sub cboMyCombo1_Change()

Me.cboMyCombo2 = ""

End Sub

This will blank out combo 2 every time a new value in combo 1 is selected.

HTH - Keith.
www.keithwilby.com
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.