Pete, did you create a form from the query? I used tables and queries to create a form in form design view and then bounce back and forth in form view to see what I need. Too hard to do over the computer. You need an access expert.
Email me the MDB and a overviw of what you want done, and I think i can do it for you. I have been using Access for about 4 years. turtlebanana@hotmail.com