Hi Every body
I have a subform where I need to display the records from a table based on the input from the main form.
For example, I have a table with studeninfo viz., studentno and marks in diff subjects.
On the main form I maintain a text box for input and a command button.
1. If I give "ALL" in that text box and click command button. All Students records pertaining to all subjects should be dispalyed in the subform.
1. If I give a particular subject name in the text box(for ex. Maths) and click command button. That particular subject records for all students should be displayed.
This should be done assigning query to a string method in the VBA code.
Can any body help me please resolving this.