I have a form that contains a job supervisor's name field. The subform has the many supervisors that could be the actual job supervisor. I want the form's supervisor field to be populated by the correct supervisor based on the user scrolling through the subforms' content . When they find the correct supervisor, I want the user to hit a button on either the form or subform (whichever you think is best) to update the form's job supervisor's name with the correct supervisor's name from the subform. Please help me determine how to make this work. Thank you.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query: