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

Kostas Konstantinidis kost36 at otenet.gr
Sat Feb 28 10:27:25 CST 2015


0simperasmata is a table on which combo simperasma_1 is based
record source
SELECT [0simperasmata].ID_symperasmata, [0simperasmata].simperasma, 
[0simperasmata].tip FROM 0simperasmata ORDER BY [0simperasmata].simperasma;

column Count 3
column widths 0cm

/kostas

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

What is 0simperasmata?  AFAIK, row Source types are limited to Table/Query,
Value List, and Field List.

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 8:08 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] limit drop down from another field...

Hi Suzan,
it breaks on line WHERE....
with a compile error Sub or Function not defined

/kostas

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

When you say it doesn't work, do you mean the control isn't populating at
all or that it isn't populating as expected?

Susan H.

On Sat, Feb 28, 2015 at 10:26 AM, Kostas Konstantinidis <kost36 at otenet.gr>
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 



More information about the AccessD mailing list