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

Hi Stuart,
well this stops the error but the combo doesn't return any data
it's just null

/kostas

-----Αρχικό μήνυμα----- 
From: Stuart McLachlan
Sent: Saturday, February 28, 2015 10:27 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
>


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com