addinf combo box to input box

[Chippie]

Is it possible to add a combo box to an input box ?

I want to display a list of current tables in a db, and allow the user to select one for which a query will be applied.

Currently I have a simple input box, from which the user enters the table name.

A combo box would be an excellent addition and, although the module has error checking, it will remove user error on selction.

Any help would be most appreciated.

 

[fynder]

Create your own form with the combo box on it. Use VBA to open the form when you need input and use docmd.runsql to run your query with the combo box as the criteria. If you don't want to see system messages, use docmd to turn of warnings until after the query runs, but don't forget to turn warnings back on. "Databases That Work The Way You Do!"

 

[Chippie]

Thankyou, but i was hoping to just run an input box from a macro. Is it possible to do it without a form ?

 

[fynder]

The form becomes the input box. A regular input box will not allow you to put a combo-box on it. You can call the form you've created from a macro just like you did the input box however. "Databases That Work The Way You Do!"