'On Enter' macro

[poul0035]

I have a text box on form A where a user would enter a number and then press enter. On Enter it would open form B. The query that is the back end of form B is based on the data entered into the text box on form A. However right now when I enter a number in the text box and press 'enter' it will open form B with no data. If I then close form B and hit enter again in that text box it will open form B with the correct data. Any way to get it to work right on the first 'enter'?

 

[boblarson]

Just so you are aware - the ON ENTER event does not mean what you think it does. The ON ENTER event is when you are coming to the text box - entering it so-to-speak.

What you want is the After Update event.

 

[poul0035]

Thanks! that did the trick.