Susan Harkins
ssharkins at gmail.com
Sat Feb 28 09:35:10 CST 2015
When you say it doesn't work, do you mean the control isn't populating at all or that it isn't populating as expected? Susan H. On Sat, Feb 28, 2015 at 10:26 AM, Kostas Konstantinidis <kost36 at otenet.gr> 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 >