Form to search multiple tables (Urgent!)
Posted on 2004-04-17
For my A-Level ICT coursework, I am making an appointment booking system, and I am stuck on creating a form to search the tables. This may sound like it could be quite simple, but it gets harder.
I have already made a form with tabs that switch between three different sub-forms (student, tutor, appointment <= The tables in use), which is OK, but I wanted to do something different.
The idea for the new search form is that there are two radio buttons, one for "Student/Tutor" search and one for "Appointment" search. When "Student/Tutor" is selected, two checkboxes underneath are made visible, "Student" and "Tutor". This would allow a customised search method for Student, Tutor, or both. Appointment searching is based on the same principle, but for AM and PM. [Also, when one of the radio buttons is selected, the checkboxes for the other radio button are made to be FALSE] It is after this that I am having problems. My first thought was to create one massive query that references all of the data, but I do not know how to change the "Show" option based upon a checkbox. Also, the query would be quite cumbersome and hard to manipulate.
I also had thoughts about having two/three different sub-forms and changing the visibility property based upon the checkboxes, but I did not know (a) whether it would work, and (b) how to do it.
Any ideas? This is due in a couple of weeks.