Hello,
I have a form called "TimesEntry " with buttons and a unbound list box calles lstTimes.
This form is to enter times worked from and to and lunch hours etc. So when I enter these times, I would like it to be shown in the list box "lstTimes".
But, however, it must be filtered by employee. So when the form is open it must only show the records in the list box for the current employee, which is on the main form as Forms!Main!txtU ser.
Would it be possible?
Some extra info.* When I open the databse, a login form appears. The employees will put in their username and password. When they log in another form opens called "Main". On this form there is an unbound field "txtUser". All the other forms are filtered by what is in the txtUser field. Hope this explains something.
Please help - I'm desperate!
Thank you in advance
Ryno
I have a form called "TimesEntry " with buttons and a unbound list box calles lstTimes.
This form is to enter times worked from and to and lunch hours etc. So when I enter these times, I would like it to be shown in the list box "lstTimes".
But, however, it must be filtered by employee. So when the form is open it must only show the records in the list box for the current employee, which is on the main form as Forms!Main!txtU ser.
Would it be possible?
Some extra info.* When I open the databse, a login form appears. The employees will put in their username and password. When they log in another form opens called "Main". On this form there is an unbound field "txtUser". All the other forms are filtered by what is in the txtUser field. Hope this explains something.
Please help - I'm desperate!
Thank you in advance
Ryno
Comment