|
 |
access thread: Limiting a combo box list in Access 2002
Message #1 by "Morris Tomlinson" <faucault@h...> on Tue, 25 Mar 2003 13:39:16
|
|
Hi All,
I set up a database a while ago in Access 98. On one form I had a ComboBox
to select from around 6000 doctors. I was able to limit this list by using
the input to another unbound ComboBox so typing in "S" only brought back
doctors whose surname begins with 'S' etc. So far so good. I am now trying
the same in Access 2002 but the code I had originally used in the criteria
of the Row Source query -
Like "|[Screen].[ActiveForm].[cboSelName]*|"
- doesn't work.
Am I overlooking the obvious or has something changed. Any clues?
Thanks in advance
Morris
Message #2 by "Kenny Alligood" <kennyalligood@h...> on Tue, 25 Mar 2003 09:08:53 -0500
|
|
Maybe if you remove the pipe characters from your string like this..
Like "[Screen].[ActiveForm].[cboSelName]*"
Kenny Alligood
>From: "Morris Tomlinson" <faucault@h...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] Limiting a combo box list in Access 2002
>Date: Tue, 25 Mar 2003 13:39:16
>
>Hi All,
>I set up a database a while ago in Access 98. On one form I had a ComboBox
>to select from around 6000 doctors. I was able to limit this list by using
>the input to another unbound ComboBox so typing in "S" only brought back
>doctors whose surname begins with 'S' etc. So far so good. I am now trying
>the same in Access 2002 but the code I had originally used in the criteria
>of the Row Source query -
>
>Like "|[Screen].[ActiveForm].[cboSelName]*|"
>
>- doesn't work.
>
>Am I overlooking the obvious or has something changed. Any clues?
>
>Thanks in advance
>
>Morris
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
Message #3 by "Derrick Flores" <derrickflores@s...> on Tue, 25 Mar 2003 21:34:09 -0600
|
|
Morris,
Try
Like [Forms]![ActiveForm]![cboSelName] & "*"
Good Luck,
Derrick Flores
San Antonio, Texas
-----Original Message-----
From: Morris Tomlinson [mailto:faucault@h...]
Sent: Tuesday, March 25, 2003 1:39 PM
To: Access
Subject: [access] Limiting a combo box list in Access 2002
Hi All,
I set up a database a while ago in Access 98. On one form I had a
ComboBox
to select from around 6000 doctors. I was able to limit this list by
using
the input to another unbound ComboBox so typing in "S" only brought back
doctors whose surname begins with 'S' etc. So far so good. I am now
trying
the same in Access 2002 but the code I had originally used in the
criteria
of the Row Source query -
Like "|[Screen].[ActiveForm].[cboSelName]*|"
- doesn't work.
Am I overlooking the obvious or has something changed. Any clues?
Thanks in advance
Morris
|
|
|
View Cart
