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

Stuart it's exactly so,

if [result_zscore_ostiki_piknotita] is null the drop down list brings the 
total of the data
but in any other value of [result_zscore_ostiki_piknotita] the drop list 
loses them



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

Ok, looked at it again:

Me.simperasma_1.RowSourceType = "0simperasmata"

RowSourceType should be "Table/Query"


-- 
Stuart

On 28 Feb 2015 at 22:51, Kostas Konstantinidis wrote:

> Hi Stuart,
> well this stops the error but the combo doesn't return any data
> it's just null
>
> /kostas
>
> ----- ----- 
> From: Stuart McLachlan
> Sent: Saturday, February 28, 2015 10:27 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] limit drop down from another field...
>
> Come on people, it's simples :)
>
> Kostas, your line:
>
> WHERE(([0simperasmata].tip) = "z")
>
> should be:
>
> "WHERE(([0simperasmata].tip) = 'z')"
>
> (You forgot the quotes around that substring that you are building
> into your SQL string)
>
>
> On 28 Feb 2015 at 17:26, Kostas Konstantinidis wrote:
>
> > 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



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