Hello,
You'll need more than a single form to solve your problem.
While your form, query and the underlying table are a good place to start, there are a few missing steps. Also, my users seem to prefer forms to switchboard entries, so I'll respond in that fashion.
1. I assume you've...