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

Rocky Smolin rockysmolin at bchacc.com
Sat Feb 28 17:03:44 CST 2015


So you 

1. took out the line of code setting the RowSourceType
2. Changed the RowSourceType in the property sheet to Table/Query
3. Fixed the Where clause 

So, now it compiles, yes?  And what do you see when you run the program and
drop the combo box 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 2:56 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] limit drop down from another field...

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 

-- 
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