I haver a table Projects where the user can with the help of checkboxes select the different Projects relevant to the record he is filling in the table.
for ex. Record 1 can have Project A and Porject B selected.
now i want to create a form where the user can search the table for projects. A form with checkboxes where he can for example can select the records in the table where Project A is selected.
the problem is when i create a form with multiple checkboxes the default value is 0 so only the Projects wich not include the Project are shown. Lets say in the search form he cheks Project A and Project B but doesnt check Project C. I need it to show all the records where Project A and B are available regardless of the situatuion of project c. Currently it shows only the records where Project A and B are selected and C is not selected. ANy help will be appreciated. P.S i am really new to this and have no VB experience
Aucun commentaire:
Enregistrer un commentaire