Is there anybody out there who can help me? (1 Viewer)

D

drisconsult

Drisconsult

Local time

Today, 15:16

Joined

Mar 31, 2004

Messages

125

• Apr 9, 2019

• #21

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

Wino Moderator

Staff member

Local time

Today, 07:16

Joined

Aug 30, 2003

Messages

36,124

• Apr 9, 2019

• #22

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).

 

D

drisconsult

Drisconsult

Local time

Today, 15:16

Joined

Mar 31, 2004

Messages

125

• Apr 10, 2019

• #23

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

Registered User.

Local time

Today, 15:16

Joined

Aug 6, 2017

Messages

1,908

• Apr 10, 2019

• #24

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.