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

And what does the combo box show after executing the .RowSource line?

Here's a thing I do when I can't figure out why a piece of SQL isn't
working:  I put a text box on the form and set the text box = to the combo
box row source.  Then I copy that SQL statement out of the text box and
paste it into the SQL view of a new query.  Then look at it in design view
and also run it to see what it actually retrieves from the tables. 1/2 the
time I find either a typo or it runs but doesn't give me what I thought I
was going to get but looking at the design view it becomes obvious.  (1/2
the time it doesn't.:))


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:42 AM
To: Access Developers discussion and problem solving
Subject: Re: [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 

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