Is there anybody out there who can help me?

[drisconsult]

Hello pbaldy
Thank you so much for taking the trouble to reply to my question.
What I need to do is to create a parameter query that when I enter into the Criteria Field the following, "Enter Student's With Grade 85%", a List Box will show me those students.
Regards
Terence

 

[pbaldy]

That should be possible. Personally I'd have the user enter that value on the form and then build SQL using it and make that the row source of the listbox. You could have the listbox row source be a query with that criteria, or better one that pointed to a textbox and requery the listbox when the value in the textbox changes (after update event).

 

[drisconsult]

May I try something else?
Is it possible to select a value from a combo box and then Update that value? If I isolate class 3A from the combo box and wish to update that class, how will I merge the update query with the combo box on a form?
Terence

 

[mike60smart]

Hi

Normal practice would be for Students to be in a specific class from a date to a date.

When you run the update of students in Classes their current Class would have their End Date updated and then another record inserted for the New Class and Startdate.