Rocky Smolin
rockysmolin at bchacc.com
Sat Feb 28 16:18:09 CST 2015
Are you still trying to make the row source type something other than 'Table/Query'? 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 12:52 PM To: Access Developers discussion and problem solving Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com