Need to click on Text Box to make the value appear

  • Thread starter Thread starter Edward H via AccessMonster.com
  • Start date Start date
E

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!
 
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
 
Nikos said:
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
Click to expand...

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.
 
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
 
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.
 
Edward said:
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.
Click to expand...

Current is the very first event on the Events tab.
 
Back
Top