John W. Colby
jwcolby at gmail.com
Sat Feb 28 11:13:18 CST 2015
I am thinking that perhaps " 0simperasmata " is the local language equivalent of table/query? John W. Colby On 2/28/2015 12:09 PM, Rocky Smolin wrote: > Try commenting that line out and setting the RowSource Type property of the > combo box to Table/Query > > > 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 9:07 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] limit drop down from another field... > > I have already done this... > Me.simperasma_1.RowSourceType = "0simperasmata" > > I can't imagine anything else > > > -----Αρχικό μήνυμα----- > From: Rocky Smolin > Sent: Saturday, February 28, 2015 6:55 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] limit drop down from another field... > > Then I think your Row Source type has to be Table/Query - no? Try that and > see if it will compile. > > 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:27 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] limit drop down from another field... > > 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 > > -- > 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 > >