I have a textbox which the user types in an ID.
this then brings up the records in a subform.
I then have some msgbox code which says that afterupdate of text box if user id = user id on the subform, then we have a existing record for the user, otherwise we do not etc.
but the msgbox routine kicks in so fast that it displays the message that we dont have that user on the database before the subform can be updated.
I put in a button rather than user afterupdate of the textbox, but still too quick.
once the focus leaves the textbox then the msgbox routine works fine. but you physically have to click off the textbox onto another part of the screen to do this. there must be a better way!!!
any ideas?
ta
John
this then brings up the records in a subform.
I then have some msgbox code which says that afterupdate of text box if user id = user id on the subform, then we have a existing record for the user, otherwise we do not etc.
but the msgbox routine kicks in so fast that it displays the message that we dont have that user on the database before the subform can be updated.
I put in a button rather than user afterupdate of the textbox, but still too quick.
once the focus leaves the textbox then the msgbox routine works fine. but you physically have to click off the textbox onto another part of the screen to do this. there must be a better way!!!
any ideas?
ta
John
