[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