I have two different time entry forms. One or the other of these forms should be visible or hidden on the main form (frmHRDB) depending on the value stored in the "TSType" field. I have code to set the 'visible' property of the two forms.
My problem is that I've attached this code to several different controls on the form so that whenever a control is clicked or whatnot the form's visible property is correct regardless of which employee is showing. But as I add more controls I'm going to have to add this code again and again. I know this can't possibly be the correct/best way to do this.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
For example, if user chooses "Work Type A" from my first column, Columns H thru J will hide and therefore, only allow user to fill information in the the showing columns.
I want to do this becaues there are a lot of work types users can be working on that each have their own set of fields to fill out so I only want the ones that apply to that work type to show.
I am using the MS switchboard to control form access, I am assuming it will be on the forms 'onLoad' event ?
My reasoning behind this is staff here use many apps but when I present them with an app that is built using ms access they think they cannot use it as for some reason in their heads it is harder to click a button using a ms access app than to click a button using a non ms access app. (PS if you hadn’t caught on my staff are incompetent and need to be shot several times in the back of the head.) So hiding the ms access window and using the popup property allows me to trick them in to believing it is just as easy I.e. I don’t tell them it is a ms access app.
In doing this now that there is no container to hold the forms that open one another depending on their function and I am wondering which would be a better practice in using Multiple.
1. Would the better practice be to show and hide forms as they open and close? I.e. the switchboard opens another form then I hide the switchboard and when that form closes I show the switchboard again.
2. Or would the better practice be not to hide any forms and just use modal property as I have been doing up until now?
I tried to hide the navigation buttons of main form which contains continuous sub form but it hides for that sub form too.
So, I tried to make my sub form as Single form & then it does show the navigation buttons of sub form but I want to show right on the main form.
Alternatively, can I replace the default navigation buttons with custom navigation buttons?
Please guide me, I really need