detect where the user goes?!

D

Daniel

Hello,

In a form, I have set it up so that when the user sets the focus on a
specific field it displays certain other fields and then when it loses the
focus it hide those same field. My problem is that although I want to hide
these fields when the user goes elsewhere, I want them to remain visible
should the user select on of them How can I acheive this?

This is the function that is called by the field's lostfocus event:
Function HideForecastComments()

Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Label63].Visible = False
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Forecast Comments].Visible = False
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Create New Record].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Goto record 1].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Go Back 1].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Go fwd 1].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Goto Last].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![RecordCounter].Visible = True

End Function

How can I detect where/what the user clicks? Basically, I would like it to
change the visibility as per the above function except when the user selects
control "Forecast Comments".

Thanks,

Daniel
 
L

lwells

What do you mean goes elsewhere? If you mean going to a new form or closing
the existing form, set your function to the forms OnExit Event. This way the
forms fields will remain visible until you close the form. Will this help?
 
D

Daniel

Maybe I should explain myself a bit more to give you the full picture. I
have been asked to add more controls to an already filled form. Of course
they do not want me to increase the size of the form (they do not want to use
scroll bars....). Anyways, back to the issue at hand, the only solution that
I could come up with was to supperpose several control and try and control
their visibility (hence my problem).

In this specific case, I have had to superpose a commentary field over top
of custom navigation buttons and also added a Forecast control where the user
will input time estimates. Basically what I am trying to acheive, maybe I'm
going about it the wrong way?, is that when and only when the user sets the
focus on the Forecast control I want the comments control to become visible
and the navigation buttons disappear. Now for my problem, when the user
choses to go elsewhere, leave the Forecast control, if they set the focus on
the comments control it remains dominant but if they set the focus on any
other control the navigation button should become dominant instead.

I'm open to any other idea on how to resolve this little problem,

Daniel



lwells said:
What do you mean goes elsewhere? If you mean going to a new form or closing
the existing form, set your function to the forms OnExit Event. This way the
forms fields will remain visible until you close the form. Will this help?

Daniel said:
Hello,

In a form, I have set it up so that when the user sets the focus on a
specific field it displays certain other fields and then when it loses the
focus it hide those same field. My problem is that although I want to hide
these fields when the user goes elsewhere, I want them to remain visible
should the user select on of them How can I acheive this?

This is the function that is called by the field's lostfocus event:
Function HideForecastComments()

Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Label63].Visible = False
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Forecast Comments].Visible = False
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Create New Record].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Goto record 1].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Go Back 1].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Go fwd 1].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Goto Last].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![RecordCounter].Visible = True

End Function

How can I detect where/what the user clicks? Basically, I would like it to
change the visibility as per the above function except when the user selects
control "Forecast Comments".

Thanks,

Daniel
Click to expand...
Click to expand...
 
M

Mauricio Silva

It looks to me your problem can be better solved using a TabControl. With it
you could create pages of controls. If you don't want the tabs to appear, you
can change the style to buttons or even none (which will look like you are
doing now)

Have a look and let us know

Mauricio Silva

Daniel said:
Maybe I should explain myself a bit more to give you the full picture. I
have been asked to add more controls to an already filled form. Of course
they do not want me to increase the size of the form (they do not want to use
scroll bars....). Anyways, back to the issue at hand, the only solution that
I could come up with was to supperpose several control and try and control
their visibility (hence my problem).

In this specific case, I have had to superpose a commentary field over top
of custom navigation buttons and also added a Forecast control where the user
will input time estimates. Basically what I am trying to acheive, maybe I'm
going about it the wrong way?, is that when and only when the user sets the
focus on the Forecast control I want the comments control to become visible
and the navigation buttons disappear. Now for my problem, when the user
choses to go elsewhere, leave the Forecast control, if they set the focus on
the comments control it remains dominant but if they set the focus on any
other control the navigation button should become dominant instead.

I'm open to any other idea on how to resolve this little problem,

Daniel



lwells said:
What do you mean goes elsewhere? If you mean going to a new form or closing
the existing form, set your function to the forms OnExit Event. This way the
forms fields will remain visible until you close the form. Will this help?

Daniel said:
Hello,

In a form, I have set it up so that when the user sets the focus on a
specific field it displays certain other fields and then when it loses the
focus it hide those same field. My problem is that although I want to hide
these fields when the user goes elsewhere, I want them to remain visible
should the user select on of them How can I acheive this?

This is the function that is called by the field's lostfocus event:
Function HideForecastComments()

Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Label63].Visible = False
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Forecast Comments].Visible = False
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Create New Record].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Goto record 1].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Go Back 1].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Go fwd 1].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Goto Last].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![RecordCounter].Visible = True

End Function

How can I detect where/what the user clicks? Basically, I would like it to
change the visibility as per the above function except when the user selects
control "Forecast Comments".

Thanks,

Daniel
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

code simplification question 1
Before update event 2
Repost:gotorecord 4
Function call 2
Problem With IsFormLoaded Do Loop Code 1
Avoid duplicate entries 1
Calculations slowing forms down - SQL server backend 0
Getting the focus on current textbox 3

Top