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

Stuart McLachlan stuart at lexacorp.com.pg
Sat Feb 28 15:18:03 CST 2015


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





More information about the AccessD mailing list