I have written a simple query with one table that does not work. The first column is an asterisk and the second is the primary key of that table, using an expression referring to a pick list out of a form. When I am in the query design window and run the query it works. When I go to the pick list and click (to run the macro that does work from the macro design window) it returns a blank record in the form in the macro. Any Ideas?
Last edited: