Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #11686

Re: combobox text

Show all headers | View raw

Am 18.03.2016 um 12:05 schrieb Remigio:
> Hi,
> on a form there's a combobox, prova, that I'd like to populate by the query q_rowsource_nascita.
> On the Enter event I put this code:
>
>      CurrentDb.QueryDefs("q_rowsource_nascita").SQL = "SELECT " _
>      & " codici_catastali.id_codici_catastali, codici_catastali.denominaizone, " _
>      & " codici_catastali.Provincia, codici_catastali.Codice " _
>      & " FROM codici_catastali " _
>      & " WHERE codici_catastali.denominaizone LIKE " & Chr(34) & Me.prova.Text & "%" & Chr(34) _
>      & " ORDER BY codici_catastali.denominaizone ASC "
>      
>      Me.prova.RowSourceType = "Table/Query"
>      Me.prova.rowsource= "q_rowsource_nascita"
>      Me.prova.Dropdown
>      
> as you can see, the query receives the combobox imput text as a parameter.
> When I press enter it says "The text doesn't correspond to any voice in the list..."
> What's wrong?
> Thank you very much
>
> Remigio
What are you trying to achieve? You are changing the underlying query of 
the current selected combobox with a text entered just entered in the 
same combobox?  Is it that what you really want to do?

Ulrich

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

combobox text Remigio <linoreale@gmail.com> - 2016-03-18 04:05 -0700
  Re: combobox text Ron Weiner <rw@domain.com> - 2016-03-18 07:46 -0400
    Re: combobox text Remigio <linoreale@gmail.com> - 2016-03-18 05:06 -0700
  Re: combobox text Patrick Finucane <patrickfinucanetx@gmail.com> - 2016-03-18 06:21 -0700
    Re: combobox text Remigio <linoreale@gmail.com> - 2016-03-18 23:33 -0700
  Re: combobox text Ulrich Möller <knobbi38@arcor.de> - 2016-03-18 21:48 +0100
    Re: combobox text Remigio <linoreale@gmail.com> - 2016-03-18 23:30 -0700

csiph-web