When I select courses in the SUBJECT enrolld List (List Box), the count either doesn’t show or shows incorrectly. How can I fix this? Please guide.

Works for me too.. post #20 shows no other values entered apart from the subjects in the combo. Would you expect that to work?
On another note: while you have found a way to add courses as a multi-value field, that is not a recommended method for longer-term / robust storing of the data. You will not for instance be able to extend your application to easily recognise students enrolled in the 2025 course in Physics or the 2024 course. Perhaps this is only a small picture of your app. However you do need to consider how to strucutre the data you wish to capture using the principles of database normalisation.
 
Call that function from the afterupdate with code and remove it from properties.
BTW, that is a combo, not a list box.
 
Last edited:
In general, use of the "=function()" construct, as shown in post #16 for "AfterUpdate", implies that you are returning a value of a returnable data type, but the property to which you are returning the value doesn't want that kind of value. Besides which, you never actually return a value from the function you DID call. Using the "Form_event" or "Control_event" properties should normally be a case of calling a code routine if you want to DO something - and that function suggests you wanted to do something. In an event-code routine, you have the proper context to do something but you don't have that context when using the "=function()" context as a property.
 
moin555 said:
check sir when i enter subject selection this messge show
Click to expand...
again i will ask you, did you Download the rectified db i uploaded. You should try it not your version.
 
arnelgp said:
again i will ask you, did you Download the rectified db i uploaded. You should try it not your version.
Click to expand...
sorry sir due to family issue i am not answering your reply . sir same issue can you reuploaded. i have 2016 MS ACESS VERSION
 
test this, you can't select a subject unless you select a course first.
 

Attachments

You must log in or register to reply here.

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom