onClick(?) help please 3

[BullHalseyUSN]

Hello, Experts!

I have a form with several sections. In each section, there are required fields that need to be filled out or my code will choke.

Adding "* Required" to each section of the form would be misleading and confusing since the fields only need to be completed if a person starts working on a particular section.

My thought is, I would like to have text appear only if a person clicks on a combobox in a section (for instance cmbAtDescription). So I thought onClick() would be a good event.

So basically, I have no idea how to craft this.

In plain English, what I would like to achieve is

Private Sub AtDescription_Click()
"When this thing is clicked, I'd like Label75 to appear

Is this possible? Thanks for any help and sorry to parade my ignorance.

Thanks!

 

[Philly44]

I don't know if this will help but look into the OnGotFocus, and the OnLostFocus events. From your desscription I think these might be what you need.

 

[hwkranger]

try:

me.[yourobjectname].visible = true



Randall Vollen
National City Bank Corp.

Just because you have an answer - doesn't mean it's the best answer.

 

[hneal98]

Yes, set those lables visible property to False ahead of time and when the object is clicked, make it the lables visible propert True, like this:

Private Sub AtDescription_Click()
me.Label75.visible = True
end sub

 

[BullHalseyUSN]

Wow...I've never seen so many fast responses. Thanks guys.

As we say "Bravo Zulu!"

I will investigate these and let you know.

 

[hneal98]

Thanks for the star.

 

[BullHalseyUSN]

NP. Everyone gets stars today! I actually wound up using onFocus so this was a group effort. hehe.

 

[hneal98]

That works too.