Kostas Konstantinidis
kost36 at otenet.gr
Sat Feb 28 09:26:56 CST 2015
Hi,
There are three fields into the same form
[result_zscore_ostiki_piknotita]--> decimal
[result_tscore_ostiki_piknotita]--> decimal
[simperasma_1] --> combo box with record source
SELECT [0simperasmata].ID_symperasmata, [0simperasmata].simperasma,
[0simperasmata].tip FROM 0simperasmata ORDER BY [0simperasmata].simperasma;
into [0simperasmata].tip are saved three different values "z", "t" and "zt"
what I need is to limit the drop down list the based on
[result_zscore_ostiki_piknotita] or [result_tscore_ostiki_piknotita] values
I tried:
Private Sub result_zscore_ostiki_piknotita_AfterUpdate()
If Not IsNull(result_zscore_ostiki_piknotita) Then
Me.simperasma_1.RowSourceType = "0simperasmata"
Me.simperasma_1.RowSource = "SELECT ID_symperasmata, simperasma, tip
FROM 0simperasmata " & _
WHERE(([0simperasmata].tip) = "z")
Else
End If
End Sub
but it doen't work
any help please?
thank's
/kostas