[AccessD] limit drop down from another field...

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
>