MICROSOFT ACCESS 2000 SELECT BOX

HI, i have three select boxes in a form which the values are used to get data , the two date fields work fine and the value is being plugged in the query  e.g  (  [Forms]![frmNotPaidOutRequest]![ActiveXCtl14].value  ) this works fine and i get my desired result. I then have another select box which is populated by a table of names which has just one column.  The problem is when i select a name from this select box the value is not being plugged in the query e.g [Forms]![frmNotPaidOutRequest]![sites].value . The weird thing is if i populate this select box with manual values it picks it up no problem..
EyeBallInSaltAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GrahamMandenoCommented:
Can you please post the SQL of your query?  Place it between [ code] and [ /code] (without the spaces) so that it is formatted as a code snippet in your post.

Also, try adding a new column in your query to list the combo box value:
SelectedSite:  [Forms]![frmNotPaidOutRequest]![sites]
(note that .Value is unnecessary)

It should show a whole column of the selected value.  Does it?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dale FyeCommented:
Have you defined these form parameters in your query?

Is there a chance that the "sites" combo or list contains two columns, one numeric, the other text, and the bound column is actually the number?

There is another possibility if the table that you are trying to filter his the "sites" column configured using the "lookup" feature.  When you open the table, it looks like you have a text value displayed in a column, but what you are actually storing may be numeric.
0
EyeBallInSaltAuthor Commented:
Thanks for your solution.
0
GrahamMandenoCommented:
My pleasure!  I'm not sure that I gave you a solution - only more questions - but I guess it pushed you in the right direction to find your own solution.  Well done!  :-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.