Rocky Smolin
rockysmolin at bchacc.com
Sat Feb 28 17:03:44 CST 2015
So you 1. took out the line of code setting the RowSourceType 2. Changed the RowSourceType in the property sheet to Table/Query 3. Fixed the Where clause So, now it compiles, yes? And what do you see when you run the program and drop the combo box 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 2:56 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] limit drop down from another field... no, it's not a good day today... it doen't want to work... it's really "table/query" my office is an English version... -----Αρχικό μήνυμα----- From: John W. Colby Sent: Sunday, March 01, 2015 12:34 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] limit drop down from another field... The other thing is that "table/query" might be something else if the Office was another language. John W. Colby On 2/28/2015 5:18 PM, Rocky Smolin wrote: > Are you still trying to make the row source type something other than > '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 12:52 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] limit drop down from another field... > > 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