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

I think you're missing the closing parenthesis in the WHERE statement --
you suppose the opening one, but not the closing.

FROM 0simperasmata " & _
   WHERE(([0simperasmata].tip) = "z")

On Sat, Feb 28, 2015 at 11:08 AM, Kostas Konstantinidis <kost36 at otenet.gr>
wrote:

> Hi Suzan,
> it breaks on line WHERE....
> with a compile error Sub or Function not defined
>
> /kostas
>
> -----Αρχικό μήνυμα----- From: Susan Harkins
> Sent: Saturday, February 28, 2015 5:35 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] limit drop down from another field...
>
> 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
>>
>>  --
> 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
>