Share via

Text box vs. Combo box

Anonymous
2011-05-12T22:24:50+00:00

I was using a form to limit data to a report.  Users typed in the smallest number into a text box and the largest number into another text box.  The criteria in the report then used a between statement to retrive the requested data.  This worked well.  I changed the text boxes to combo boxed, so the users could pick from a menu and now the report will not work.  controls are still named the same.  What am I doing wrong?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2011-05-12T22:49:40+00:00

For combo's you need to make sure that the BOUND COLUMN is set to the right column which returns the correct value.  Make sure the combo is returning the value you think it is.

Was this answer helpful?

1 person found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-05-12T23:45:09+00:00

    Will not work is kind of vague. What is happening?  It won't open?  It isn't displaying what you expect?  It doesn't display anything?

    Daniel Pineault - 2010 MVP

    http://www.cardaconsultants.com

    http://www.devhut.net

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2011-05-12T22:50:14+00:00

    How many columns does your combo have?  What are they?

    Post your SQL.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments