Query dialog box pull down

[skelley]

Have a form based on a query where user types in his name in a dialog box to display just his records. Is there a way for that dialog box to be a pull-down list so the user can just select his name instead of typing it?

 

[Dreamboat]

Sure. Make sure you're in design view of the form and you are viewing the control toolbox (view-toolbars). Select the list box and the wizard should pop up asking you where you want to look in for the value (the query's field name) and whether you want to just use it or store it (you'll use it).