Let me preface this with I dont know if this would be an on load, or on open. My form is already technically "open", but I am doing a docmd.openform to move to a different record.
In the combobox, I have code in an after update even to move to a specific record determined by the value selected in the combo box. The problem is when the form "reopens" or loads to that record (I REALLY don't know which is technically being done), the combo box just defaults to its first value. How can I have it show the value of the record it is actually on?
An an example would be like such:
Combobox with Name1, Name2, Name3 as available selectable options.
You choose Name2 which then moves to the record Name2 but after moving to that record, the combobox just displays Name1 since it is first in the list. I would want it to show Name2.
This is probably another simple option I have missed somewhere within properties.
In the combobox, I have code in an after update even to move to a specific record determined by the value selected in the combo box. The problem is when the form "reopens" or loads to that record (I REALLY don't know which is technically being done), the combo box just defaults to its first value. How can I have it show the value of the record it is actually on?
An an example would be like such:
Combobox with Name1, Name2, Name3 as available selectable options.
You choose Name2 which then moves to the record Name2 but after moving to that record, the combobox just displays Name1 since it is first in the list. I would want it to show Name2.
This is probably another simple option I have missed somewhere within properties.