This has been driving me bananas. Can anyone suggest why a drop down list on a Data Access Page (dap), which has a query as it's rowsource and should display a list of several values, only displays one?