Sorry admin, i don't know which place to place the thread as non of them have access
I have a problem with access query, i need to query the checkbox who have check it.
I have 1 table, 1 query & 2 form
The table consist of 1 name & 1 checkbox
The form consist of 2 form, checkbox, result
checkbox - a form which will send the input to the query (either check or uncheck to display check result or uncheck result)
result - display the form base on query
The query will capture input from checkbox form and the result form will display it
i based on my previous query using a dropdown box which is [forms]![checkboxform]![checkbox] to query out which name have check the checkbox.
but nothing is display..so i suspect the problem lies with the synax of the query...so can someone guide me how to solve the problem so that i can advance to the next step.