Access 2007 - Subform refresh fun
Posted on 2011-10-15
I would like to refresh a subform on a form every time I enter a letter of someones surname into a textbox. If I use the "me.refresh" command everything works a treat. However, it selects the textbox and highlights all of the text so when the user goes to enter the second letter of their search it overtypes the first one. Ideally I would just like the subform refreshed each time a key is pressed in the textbox mentioned above, if it is possible?
Form is: frmStaffToTask
Subform is: frmMemberAreaDetails
Textbox is: txtSurnameQuickSearch
Any help would be appreciated, many thanks in advance, Alan.
I have a workaround which keeps the me.refresh and then sets focus of the textfield and then goes to the end of the textfield but it just does not feel clean.