D
DS
I have a combo box whos rowsource is set from another combobox. The
problem is that after I select a record in a the second box, it always
requeries itself tothe first record even though the value it's setting
is the one I selected. Any help why this is happening I would
appreciate it.
Thanks
DS
Private Sub CmbMenu_AfterUpdate()
Me.TxtMenu = Me.CmbMenu.Column(0)
With Me.CmbMenuSections
.RowSource = "SELECT MenuInfo.MenuID, MenuInfo.MenuCatID,
MenuCats.MenuCat " & _
"FROM MenuInfo INNER JOIN MenuCats ON MenuInfo.MenuCatID =
MenuCats.MenuCatID " & _
"GROUP BY MenuInfo.MenuID, MenuInfo.MenuCatID, MenuCats.MenuCat " & _
"HAVING (((MenuInfo.MenuID) = [Forms]![Easy28]![TxtMenu])) " & _
"ORDER BY MenuCats.MenuCat;"
.Requery
End With
End Sub
problem is that after I select a record in a the second box, it always
requeries itself tothe first record even though the value it's setting
is the one I selected. Any help why this is happening I would
appreciate it.
Thanks
DS
Private Sub CmbMenu_AfterUpdate()
Me.TxtMenu = Me.CmbMenu.Column(0)
With Me.CmbMenuSections
.RowSource = "SELECT MenuInfo.MenuID, MenuInfo.MenuCatID,
MenuCats.MenuCat " & _
"FROM MenuInfo INNER JOIN MenuCats ON MenuInfo.MenuCatID =
MenuCats.MenuCatID " & _
"GROUP BY MenuInfo.MenuID, MenuInfo.MenuCatID, MenuCats.MenuCat " & _
"HAVING (((MenuInfo.MenuID) = [Forms]![Easy28]![TxtMenu])) " & _
"ORDER BY MenuCats.MenuCat;"
.Requery
End With
End Sub