Updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI,

I have 2 combo boxes and the way they are set up...
2nd combo box values are dependent upon what selected in combo 1.

I got it working to a point that if A is selected from Combo 1 - then it
will show products related to A, so on...

Problem I am having is, Lets say if I change from A to B in Combo 1 - the
value in combo box is still the same that was chosen for A, but if i click
on drop down, it has products related to B.

How do I delete the value from Combo box 2, once the value in combo box 1
has been changed. any help will be greatly appreciated.
 
Hi.

In the Change event for Combo1, place this code:
Me.Combo2 = ""

-Michael
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cascading combos in datasheet 0
Populate a text box based on a combo box 1
Re: Pass field value selected in Combo Box to SQL Query 1
Combo Boxes 4
Populate a text box after update 4
Choose a value from a combo box based on a text box 0
Combo Box Error 2
Combo box to fill text boxes.. 3

Back
Top