asked on

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..

ASKER CERTIFIED SOLUTION

Graham Mandeno

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Dale Fye

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.

EyeBallInSalt

ASKER

Thanks for your solution.

Graham Mandeno

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! :-)