Cascading combos in datasheet

Apr 8, 2011
Reaction score
I have a subform in a form and in this subform I have 2 combos. In 1st combo I select a value and base on this value I want the 2nd combo to refresh the values. As far here works ok. When I select the value of 2nd combo all values in datasheet of that field changes !!! I dont want that !!!

How can I solve that? Is there any way ?

I wrote code in vba here is my code:

Option Compare Database
Const strsql4 = "SELECT Subgame FROM Games WHERE Game = '"
Const strsql3 = "'"

Private Sub Game_Name_AfterUpdate()
gamenameval = Me.Game_Name.Value
strsql5 = strsql4 & gamenameval & strsql3
Me.Subgame.RowSource = strsql5
End Sub

Please notice that the subform want it in datasheet form.

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