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

Kostas Konstantinidis kost36 at otenet.gr
Sat Feb 28 10:08:14 CST 2015


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 



More information about the AccessD mailing list