Tina Norris Fields
tinanfields at torchlake.com
Sat Feb 28 14:55:44 CST 2015
Oh, my - went right by that one and never saw it. :-) TNF Tina Norris Fields tinanfields-at-torchlake-dot-com 231-322-2787 On 2/28/2015 3:27 PM, Stuart McLachlan wrote: > Come on people, it's simples :) > > Kostas, your line: > > WHERE(([0simperasmata].tip) = "z") > > should be: > > "WHERE(([0simperasmata].tip) = 'z')" > > (You forgot the quotes around that substring that you are building into your SQL string) > > > On 28 Feb 2015 at 17:26, Kostas Konstantinidis wrote: > >> 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 >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> >