VBA text problem

[KORCARI]

Hi Working in MS Access VBA want to enter a number in textbox and return some text in another textbox. For example when enter 1 want to return in another textbox Boston. How to make this possible? Regards

[ChandraRam]

KORCARI wrote:

Working in MS Access VBA want to enter a number in textbox and return some text in another textbox.
For example when enter 1 want to return in another textbox Boston.
How to make this possible?

Create a form with the two text boxes. Each text box has events associated with it. In the AfterUpdate event of the first text box, check for the value entered and accordingly fill value(s) in the second text box. HTH :)

[Dalek Dave]

Would also suggest you use CASE, much easier to follow and edit.

------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] Trolls[^]