***Need help on setting up a box in a form

[Gift Tun]

Hello,

I am an one month old Access user and I am having a problem with the form I ceated. I am wondering if anyone can guide me a trick to solve my problem.

A purpose of my form is for staff members to be able to update their clients' information. The client names will be assigned to one of the three staff members. My logic is once a staff type in his/her name, the client names that are assigned to his/her will come up (it can be in another box) and they can choose to enter information to that paticular client.

1. Is there a way that I can create a box for the staff that can put their names in and it will automatically filter my Master table to show only the client names who belong to that staff?

Please let me know if I am not clear enough.

Thank you so much indvance

 

[vapid2323]

Not sure how you have everything setup but I would do th following.

Have my staff table be the main form then have a clients table as a subform.

THis means that what ever staff memeber is currently active it would filter the client list below.

To change staff memebers just use the combo box wizard, I will create a dropdown box for the staff memeber to choose there name and force the form to show that staff memebers record and clients list.

 

[Gift Tun]

Thank you so much for your great advice!!!