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

Hi Rocky,
yes, it stops on Where

/kostas

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

Have you put a break point in that after update module and stepped through
it to see if it's executing?

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com