My issue is that I wish to display a list of a particular student's interests - IT, Music, Drama, whatever.
A listbox works fine for this, however I can find no way of modifying the list, as you cannot directly edit a listbox.
Basically what I wish to do is display an editable list of all interests associated with that student.
I currently have a combo box which displays a list of all interests currently entered. I would like to be able to select/type something here, and have a button create a new record of that interest, associated with the selected student's ID. This will effectively add that interest to the listbox.
If anyone can think of an alternative way of achieving this, I'm open to suggestions.
Thanks in advance,
Last edited by frekster22; 01-06-05 at 01:25.
Reason: Reworded question
This is kinda complicated since i dont have you form structure. but the simple way is a button to bring up a form that shows that students interests in datasheet view, add the new interest , close the form , and then have a button on the original form that can requery the list box.
Basically make a button with it's on click event set to nameofyourlistbox.requery.
Or on the form that just popped up put this code in the new forms on close event.
Thanks guys for the suggestions. I have considered something similar (that is, using a seperate form), and it looks like I will end up using briley's suggestion.
If possible, however, I would like to achieve this using only the one form. I'll live if this is not possible, but I always like the elegant solution
As can be seen in the attached picture, this database will be used to keep track of students and their directions in life. The two boxes underneath the Areas of Interest heading are causing the problem. The list box shows those interests associated with the student, and the combo box gives a list of all previously entered interests. A button would be added to the right of the combo box.
Can anyone think of a way to achieve my goal of adding one to the other without opening another form? Otherwise I'll stick with briley's idea.