check boxes

[kbreiss]

I have a form called project managers..... I would like to display only distinct managers. I tried to use a query that grabbed distinct managers, but then the recordset was not updatabable.

Also, I am using a check box next to the manager text box so they can select the manager. Ideally, once a manager has been selected you can view all projects underneath that manager. Does anyone have any clue how this could be done? If I just use the table it shows all the managers even if they are duplicates.

Any advice on this would be greatly appreciated.

Thanks,
Kacy
________
Rhode Island Medical Marijuana

 

[DES]

I could have a look at it for you if you would like to send me a copy to work with. Of course trash any confidential data.

Send to technoweenie@sympatico.ca

 

[kbreiss]

Basically the form Add_Projects is the start page.

When you click on Track by Managers you will notice Kacy Reiss as a manager twice.

I was wondering if there is anyway to display managers (Kacy Reiss) only once then when you click on View Projects on the Project_Manager form it would display all the projects under that manager.

Notice I created a blank field that I set to null upon opening fields. When the user clicks in the check box it sets the blank field to -1. This is how I run my queries to get the selected data.

If this is going to be too difficult I can live with manages showing up as many times as it it is in the table. Ordinarially, I would create a managers table, but managers change with each project.

Any advice would be appreciated.


Kacy
________
Milf mature

 

[DES]

sent you the fix