Subform w/ 2 combo boxes

[gleegeld]

Hi, I know that this question has been asked many time in various forms, but I still need help.

I have a subform in datasheet view that has 2 combo boxes, Category and Products. After selecting the Category, I need the Products combo box to show only those products related to the category selected.

If someone could send in a sample db that would be great.
gleefeld20@msn.com

Thanks,
Gleegeld

 

[MazeWorX]

Private Sub Combo1_AfterUpdate()
With Me
.Combo2.Requery
.Combo2.SetFocus
.Combo2.Dropdown
End With
End Sub

Private Sub Combo1_GotFocus()
Me.Combo2 = Null
End Sub

Combo2 Row Source

SELECT Table1.Field1, Table1.field2
FROM Table1
WHERE (((Table1.Field2)=[forms]![frmYourFormNameHere]![Combo1]));




Remember amateurs built the ark - professionals built the Titanic

 

[gleegeld]

Hi MazeWorX,

I did what you said, but I am still running into the same problems that I have had all along. Because I am in datasheet view, when I go to the next row the selection from the previous row goes away. I am not sure why this is happening. Do you have any clues?


Gleegeld

 

[brucomela]

ok...that's exactly my problem!! Is there any way out?!...ok, I can admit it: this is clearer than mine!!

HELP PLEASE!

 

[Luther1978]

A third person with the same problem. Surely its a common requirement of Access ?

a Still Frustrated

Martin