Combo Box that doesn't allow selection

[Ted C]

If you're trying to use that as a record finder, try the combo box wizard, choosing the third option, "Find a record...". It will create it for you (the combo will not be bound to the underlying data).



Or, if that's supposed to select the session (and I'm just glancing at the data), perhaps it should be bound to the DClassEventID field in tblClassAttendance or some other table?

Obviously I'm not clear on what you're trying to accomplish.

It's bound column is the ClassEventID, which determines what class session the students will be enrolled in when the btnEnroll_click() event runs. It should also determine what shows in the other fields at the top of the form: ClassName, ClassType, SessionDate, etc. That way the user can see the important details of the session and know s/he has picked the right one. All those other fields are disabled and locked.

I don't actually want to edit any information about the class session from this form, I only want to choose a class session for enrolling students.

[pbaldy]

But wouldn't that chosen class session be saved in tblClassAttendance?

Actually now that I think about it, this is for the multiselect append, right? That form should probably not be bound to any table or query. I'd have a combo with a row source that included all the necessary fields, but no control source. For your other textboxes, they'd have a control source of:

=ComboName.Column(x)

where x is the column containing the relevant info. When you make a selection from the combo, they will update to display the data.

[Ted C]

But wouldn't that chosen class session be saved in tblClassAttendance?

Actually now that I think about it, this is for the multiselect append, right? That form should probably not be bound to any table or query. I'd have a combo with a row source that included all the necessary fields, but no control source. For your other textboxes, they'd have a control source of:

=ComboName.Column(x)

where x is the column containing the relevant info. When you make a selection from the combo, they will update to display the data.

Will give that a try

[Ted C]

I'd have a combo with a row source that included all the necessary fields, but no control source. For your other textboxes, they'd have a control source of:

=ComboName.Column(x)

where x is the column containing the relevant info. When you make a selection from the combo, they will update to display the data.

The combo box (SessionID) is now unbound. It's populated from an independent query that gets SessionID, ClassName, ClassType, SessionDate, LocationName, and Instructor.

The ClassName field's control source property is now SessionID.Column(1).
The Type fields source is SessionID.Column(2).
Etc.

I can now select an ID number in the SessionID combo box, but the other text fields don't populate with data.

[pbaldy]

I have it working with a rough test. Are you including the = at the beginning of the other textboxes? Also make sure the column count property of the combo is appropriate. It probably isn't if you added fields to the existing combo.

[Ted C]

I have it working with a rough test. Are you including the = at the beginning of the other textboxes? Also make sure the column count property of the combo is appropriate. It probably isn't if you added fields to the existing combo.

The "=" sign makes the difference. I guess it just looked too weird when Access automatically changed "SessionID.Column(1)" to "[SessionID].[Column](1)" when I added the "=" sign.

I had actually realized I needed to update the column count, though.