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

Kostas Konstantinidis kost36 at otenet.gr
Sat Feb 28 16:56:26 CST 2015


no, it's not a good day today... it doen't want to work...
it's really "table/query" my office is an English version...


-----Αρχικό μήνυμα----- 
From: John W. Colby
Sent: Sunday, March 01, 2015 12:34 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] limit drop down from another field...

The other thing is that "table/query" might be something else if the
Office was another language.

John W. Colby

On 2/28/2015 5:18 PM, Rocky Smolin wrote:
> 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 



More information about the AccessD mailing list