G
GB
I have a primary form that has a subform on it. On the primary form I have
two unbound controls. 1 is a combo box that pulls data from a table, the
other is a "text" box that I filter for numbers only (and the delete key).
When data is entered into both of the boxes, then the data is used to search
for the matching record in the primary form, and subsequently the multiple
items are pulled into the subform that correspond to the primary form data.
The problem I have is that when I have completed typing the last of the
information in the text box and press the tab key to move to my button that
does additional work on the data, the focus does not move to the button until
I press the tab key a second time. This occurs if the data of the text box
has changed from the previous data. If I enter the text, press the tab, then
delete the information in the text box and retype it in exactly as it was
originally and then press the tab key, it will go directly to the next
control (my button that I want to then click). Also if I complete typing the
data (changed from the previous entry) then click directly on the button
without first tabbing (or clicking) away from the text box, then it performs
actions on the form, but with bad effects.
What is going on here, and how do I make it move to the next control after
updating the data in my fields?
This "same" code works fine when I don't have a subform, so I'm thinking
that it has something to do with refreshing the subform data. I created the
code of this form from a previous working one, though I didn't copy the
entire form and then modify the code. So wondering if there is some setting
on either the primary or subform that is causing the problem. Access Version
is 2003.
Thank you for any assistance.
two unbound controls. 1 is a combo box that pulls data from a table, the
other is a "text" box that I filter for numbers only (and the delete key).
When data is entered into both of the boxes, then the data is used to search
for the matching record in the primary form, and subsequently the multiple
items are pulled into the subform that correspond to the primary form data.
The problem I have is that when I have completed typing the last of the
information in the text box and press the tab key to move to my button that
does additional work on the data, the focus does not move to the button until
I press the tab key a second time. This occurs if the data of the text box
has changed from the previous data. If I enter the text, press the tab, then
delete the information in the text box and retype it in exactly as it was
originally and then press the tab key, it will go directly to the next
control (my button that I want to then click). Also if I complete typing the
data (changed from the previous entry) then click directly on the button
without first tabbing (or clicking) away from the text box, then it performs
actions on the form, but with bad effects.
What is going on here, and how do I make it move to the next control after
updating the data in my fields?
This "same" code works fine when I don't have a subform, so I'm thinking
that it has something to do with refreshing the subform data. I created the
code of this form from a previous working one, though I didn't copy the
entire form and then modify the code. So wondering if there is some setting
on either the primary or subform that is causing the problem. Access Version
is 2003.
Thank you for any assistance.