Form With Subform Access 2000

[Chester1]

I have a main form that holds details of courses and a subform that holds the
information about the people who are attending each course.

I have created a combo box on the Course date field in the main form to find
records based on the date selected this works fine but my problem is on the
half day course ie 2 courses on the same date it will pick up one but will
not then not change to the other. The field that differenciates between the
courses is a filed called courseID

 

[Arvin Meyer [MVP]]

Use the CourseID as the bound column of the combo (usually the first column)
and set its width to 0".

Don't dorget to add 1 to the column count property. You can still sort and
choose by date.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access