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

I think one problem is that you do not put the NAME of the table in that 
property but the STRING value 'Table/Query'

John W. Colby

On 2/28/2015 1:00 PM, Kostas Konstantinidis wrote:
> Hi Dan,
> the original table's name begins with 0 (zero)
> I renamed it but it also refuses to execute
>
> thank's
>
> /kostas
>
> -----Αρχικό μήνυμα----- From: Dan Waters
> Sent: Saturday, February 28, 2015 7:32 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] limit drop down from another field...
>
> Hi Kostas,
>
>
> Take a look at this in your text:
>
>        '0simperasmata' is typed in your example with a leading zero.
>
>        'Osimperasmata' is typed with a leading 'O'.
>
> At least variables cannot be named with a leading number.  I checked 
> and it
> is possible to name a table in both Access and SQL Server with a leading
> number - I was surprised!
>
> Perhaps changing the leading zero to a leading O might help?
>
> Good Luck!
> Dan
>
> -----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:27 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] limit drop down from another field...
>
> 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
>