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

+1

John W. Colby

On 2/28/2015 10:54 AM, Rocky Smolin wrote:
> 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
>
>