Combo Box in Queries

[CharlesCount via AccessMonster.com]

When I run an append query I set it up to ask for an item number, can I
include a drop down list of the items to select from? (A combo Box)
I only use Macros I am not familiar with script or programming.

Thanks

Charles

 

[Ken Snell \(MVP\)]

Not within the macro or query. But you can build a form with a combo box on
it, open the form and let the user select the value, then have the user
click a button to run the query and let the query read the value from the
form (remember to not close the form before the query runs) -- for example:

SELECT *
FROM TableName
WHERE FieldName = Forms!TheNewForm!ComboBoxName;