Search results

Success! andy cheers for all the pointers, it now works fine, although one thing I ralised is that you have to accomadate for the checkbox to be false in the syntax otherwise the resulting query does not show up any data. many thanks for all your help. John

Thanks, now the next step!! Andy that works, many thanks, I had put the expression on the incorrect row within the query. my next step is to bring up only those records where they are blank within that field (call it pupil name) so, the user selects the project field checkbox. the query...

ta! many thanks!!

Sure this must be an easy one, but it is driving me crazy. i have a drop down list so that the user selects which project they want to view , and the subform brings up the data. problem is that the combobox has duplicate entries, i.e. many projects with the same code. is there any way to make...

help! I am trying to create a query based on the checkboxes a user selects within a form. The idea being that the user chooses from a selection of fields via checkboxes. the query then runs an If statement on the checkbox (if checkbox = Yes then show all blank records in that field) and...