List Box Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using a form with an unbound textbox to pass a parameter to a query. The user needs to type in a character or characters but I would like them to select from a list box. However when I do that it seems like it doesn't pass the data to the query. I'm using Access 2000. Any help would be appreciated in advance. Thanks Paul
 
A listbox should work, if its bound column is the same field that the query
is using. One way this might not be happening is if a field has been
defined as a "lookup" data type, which stores a value, but displays
something else (this is why the lookup data type is held in such low regard
in the .tablesdbdesign newsgroup!).

You didn't mention how you were using the listbox to "pass" the parameter.
Could you post the SQL of your query?

By the way, if you have fewer than 6-8 choices, I can see using a listbox.
If more, consider a combo box instead.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top