Dropdown in Access 2007 parameter query. Why not working

Posted by waanders on Stack Overflow See other posts from Stack Overflow or by waanders
Published on 2010-05-19T10:27:42Z Indexed on 2010/05/19 10:30 UTC
Read the original article Hit count: 231

Filed under:
|

Hello, I want a Access parameter query to ask an user for a value (a location in this case). When I type [Enter location] in the Criteria field it works fine: I get a dialog box (Enter Parameter Value) with a textbox and my text (Enter Location). So far, so good. This works (the result also).

But now I want a dropdown/combobox (instead of a textbox ) for the user to pick a location. I made a form and type Forms![Form1]![CmbLocation] in the Criteria field.

Like this: http://office.microsoft.com/en-us/access/HA011170771033.aspx

But I still get a textbox (with the reference as textlabel).

What am I doing wrong? Has anybody any advice?

© Stack Overflow or respective owner

Related posts about ms-access

Related posts about ms-access-2007