Create Drop Down Menu in ACCESS Query

[bwlytkr]

Is there a way to create a drop down menu so that the menu will show up in the excel column when I run the Access Query? I tried building the drop down menu in the table but, the menu does not show up when I run the query in excel. Any help would be greatly appreciated

 

[JonXL]

What kind of query did you build? Are you able to edit any of the fields from the query?