dgent81
New member
- Local time
- Today, 12:35
- Joined
- Jul 21, 2021
- Messages
- 3
The control is a combobox (Patient) on a detail subform. As you make entry the grid automatically shows the user a new add row right below it with the controls repeated. A typical grid. I can reference the control they are touching using Me.Patient and that works fine, but I want to do like jQuery and other coding can do and talk to the control right above it if it is there with the same name. So if Me.Patient they are on is on row 3 (How to know is a question) then I want to be able to control the same control on the first row...Patient[1] or the row preceding Patient[3-1]
Access has to know which row the control is on and since the control name is the same there has to be a way to define the row or ask the lower bound or upper bound of the rows being shown in the detail pane of the subform. I realize this is not jQuery and maybe Access does not expose this to the VBA
My goal is to set the control that has gotFocus (Me.Patient) to the same selected option/id/name as the preceding control with the same name if row > 0 thus saving the user time and not requiring them to type in and find the same persons name in the list. The control has the same list of patients as it is based on the same query as it is the same control.
Access has to know which row the control is on and since the control name is the same there has to be a way to define the row or ask the lower bound or upper bound of the rows being shown in the detail pane of the subform. I realize this is not jQuery and maybe Access does not expose this to the VBA
My goal is to set the control that has gotFocus (Me.Patient) to the same selected option/id/name as the preceding control with the same name if row > 0 thus saving the user time and not requiring them to type in and find the same persons name in the list. The control has the same list of patients as it is based on the same query as it is the same control.