I'm using Access 2007.
I have a form that captures comments (comment table). The form captures the date, the comment, and the employee ID of the person making the comment.
I have a combo box on the form that lists employee id and employe name via a query on the employee table.
Employee ID is the bound field to the comment table.
When you login to the application I store your employee ID in a field in a public module.
How do I make the combo box default to the employee ID row that matches the employee ID in the public module?
I have a form that captures comments (comment table). The form captures the date, the comment, and the employee ID of the person making the comment.
I have a combo box on the form that lists employee id and employe name via a query on the employee table.
Employee ID is the bound field to the comment table.
When you login to the application I store your employee ID in a field in a public module.
How do I make the combo box default to the employee ID row that matches the employee ID in the public module?
