Rocky Smolin
rockysmolin at bchacc.com
Sat Feb 28 10:13:45 CST 2015
What is 0simperasmata? AFAIK, row Source types are limited to Table/Query, Value List, and Field List. R -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas Konstantinidis Sent: Saturday, February 28, 2015 8:08 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] limit drop down from another field... 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