custom dialog box

[Legacy 15162]

I've done my due diligence in regards to looking online and learning how to create a custom dialog box. I have followed the examples but am still running into trouble. I am currently using access 2000.

I created my custom box and have inserted this into the criteria portion of my query.

[Forms]![dlgDivision Selection]![cboDivisionSelect]

When I go to run the query it asks me to enter the parameter value. It does not appear to be showing my combo box and/or form (dialog box) that I created. What am I missing?

 

[mdmilner]

First thing. As a general suggestion, do not use multi word names for anything. Always connect them doing something like FirstLast or First_Last. You can work around this, it's just easier.

So, if I get this right, you have a combo box that uses a query as it's source. I'm guessing you're using a Query that shows up under the Query tab and when you execute it fails? What about when you open the form and hit the drop-down box?

When you get a parameter request, it usually means you either are using a non-existent fieldname or you've put a prompt inside [] brackets in a WHERE parameter...something like [What is your name?].



Mike

 

[Legacy 15162]

I ended up just creating a subform. In the combo box that lists my criteria I just added an After Update procedure using me.refresh. Seems to work fine.

 

[youngborg]

Hi, I have a similar issue getting the query to play with the criteria in the unbound combo box on my dialog form.

The query is a crosstab query with regional information. I would like to be able to select a specific region, or run the query including all regions. I'm starting to think it might be impossible with a crosstab query...

Any help will be appreciated!!!