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

Kostas Konstantinidis kost36 at otenet.gr
Sat Feb 28 11:31:27 CST 2015


Hi John,
yes it's the greekish word for something like "conjectural"
but I never use greek language or characters as table names of field names 
as well
so table's title is in latin characters

/kostas

-----Αρχικό μήνυμα----- 
From: John W. Colby
Sent: Saturday, February 28, 2015 7:13 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] limit drop down from another field...

I am thinking that perhaps "

0simperasmata

" is the local language equivalent of table/query?

John W. Colby

On 2/28/2015 12:09 PM, Rocky Smolin wrote:
> Try commenting that line out and setting the RowSource Type property of 
> the
> combo box to 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 9:07 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] limit drop down from another field...
>
> I have already done this...
> Me.simperasma_1.RowSourceType = "0simperasmata"
>
> I can't imagine anything else
>
>
> -----Αρχικό μήνυμα-----
> From: Rocky Smolin
> Sent: Saturday, February 28, 2015 6:55 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] limit drop down from another field...
>
> Then I think your Row Source type has to be Table/Query - no?  Try that 
> and
> see if it will compile.
>
> 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:27 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] limit drop down from another field...
>
> 0simperasmata is a table on which combo simperasma_1 is based record 
> source
> SELECT [0simperasmata].ID_symperasmata, [0simperasmata].simperasma,
> [0simperasmata].tip FROM 0simperasmata ORDER BY 
> [0simperasmata].simperasma;
>
> column Count 3
> column widths 0cm
>
> /kostas
>
> -----Αρχικό μήνυμα-----
> From: Rocky Smolin
> Sent: Saturday, February 28, 2015 6:13 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] limit drop down from another field...
>
> 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
>
>
> --
> 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
>
> --
> 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