Hi all,

I am creating a database for my college’s adult sector which will be used to store:

• Student details/enquiries about courses at the college
• Course details
• Lecturer details

I have just begun setting up a form to add student enquiries to the system. I would like the form to contain a subform where up to 5 choices of course can be selected. I have attached a screenshot of the form as it currently stands.
I would like for the CourseID drop down box in the subform to be able to be pulled down and for the Course Name and Start Date fields to be dependent upon this. Currently, when I try to select the CourseID from the drop down box I get an error stating: “Control can’t be edited; it’s bound to AutoNumber field ‘CourseID’.” Also, I need to be able to somehow search for courses (preferably by entering the first few letters of a course name) and then be able to select the correct course and have it entered into the subform. CourseID is currently the primary key and all the relationships seem to be set up correctly.
Any help would be greatly appreciated!

Thanks,


Joel.