Private Sub Combo21_AfterUpdate() Dim GID Dim SQL As String Me.Text14 = "" GID = Me.Combo21 If GID = "" Then GoTo Kraj If GID = 1 Then Me.Cena.ControlSource = "Pcena" Me.Label8.Caption = "Prodajna cena" SQL = "SELECT SifraArt, BrojacQ([Sifraart]) AS Brojac, ImeArtikla, JM, PCena, ResetQ() AS R " _ & "FROM K_Artikli " _ & "WHERE GID=1 " _ & "ORDER BY ImeArtikla" ElseIf GID = 2 Then Me.Cena.ControlSource = "NCena" Me.Label8.Caption = "Nabavna cena" SQL = "SELECT SifraArt, BrojacQ([Sifraart]) AS Brojac, ImeArtikla, JM, NCena, ResetQ() AS R " _ & "FROM K_Artikli " _ & "WHERE GID=2 " _ & "ORDER BY ImeArtikla" End If Me.List2.RowSource = SQL Me.List2.SetFocus Me.RecordSource = Me.RecordSource Izlaz: Exit Sub Kraj: End Sub