[MS_AccessPros] RE: this is to reply to Bill Wrmosca. (Hi Bill I have no idea why the Reply button's not working) How do I or is it possible to use the BRING TO FRONT and SEND TO BACK in VBA code?

 

Thanks Bill

 

If the focus was shifted away from the combo box, it will create an error 2185. This is the trouble that I was telling Glenn Lloyd (see below message) earlier. I think I just have to go with Duane's suggestion – make the combo box to display multiple columns…

 

Phucon

 

Hi Glenn, as a matter of fact the text box's value is a Tempvars which was created and captured after the combo box was updated. The trouble is, the combo box has an On Change event procedure, so each time if the focus was shifted away from it (to show the text box) the error 2185 will pop up. In fact I can simply just drag the combo and place it above the text box. However this will show both the combo and the text box, it just does not look that pretty to me J Anyway I think I will set the combo box up, displaying multiple columns like what Duane suggested. Thanks again. Phucon

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___