Need to click on Text Box to make the value appear

[Edward H via AccessMonster.com]

I have a weird error.
I made a text box that obtains it's value from a subform.
Strangely enough, the value will only show up when my mouse clicks the
textbox.
The value is set update 'On Enter' and not on click, so I don't know why it
would do that.

HELP!

 

[Nikos Yannacopoulos]

Edward,

Maybe you are misled as to the meaning of "On Enter"; this event fires
whenever the control is entered into, i.e. the cursor gets there (be it
by tabbing through the form controls or by a mouse click). What did you
have in mind? Perhaps there is a more appropriate event you should be
using. Care to describe in plain english what the goal is?

HTH,
Nikos

 

[Edward H via AccessMonster.com]

Edward,

Maybe you are misled as to the meaning of "On Enter"; this event fires
whenever the control is entered into, i.e. the cursor gets there (be it
by tabbing through the form controls or by a mouse click). What did you
have in mind? Perhaps there is a more appropriate event you should be
using. Care to describe in plain english what the goal is?

HTH,
Nikos

Ok, what I wanted is that once I enter the form I want all the values to
appear.
One of the fields is an unbound textbox, and is filled with by a field by a
Subform.

My problem is that when I get in the form, the values don't show up. They
only show up after I click on the textbox. I don't get why, and it bugs me.

 

[Nikos Yannacopoulos]

Edward,

There is no Ebter event for the form object! The one you used belongs to
the textbox itself.
Form events you might try:
On Open: fires once, when the form is opened
On Load: fires once also, after the On Open event
On Current: fires when the form opens, and then everytime you move into
another record (existing or new)

My guess is the Current event is what you want actually.

HTH,
Nikos

 

[Edward H via AccessMonster.com]

Thank you Nikos.

I was looking at all of the events.
There is On Opne and On Load but no On Current
othersiwe I would have used that already.

 

[Nikos Yannacopoulos]

No Current event for the form object? Which version of Access are you on?

 

[Rick Brandt]

Thank you Nikos.

I was looking at all of the events.
There is On Opne and On Load but no On Current
othersiwe I would have used that already.

Current is the very first event on the Events tab.