Combo Box that doesn't allow selection

[Ted C]

Still on that training database, my enrollment form has a combo box for selecting the class session. The query that populates the combo box has three columns, and column 1 is the bound column.

My problem is that while I can click the arrow and see the list of results, I can't click one of them to change the value of the combo box. It defaults to one when the page opens (SessionID = 27, incidentally), and it won't change the selected item.



Anyone familiar with this problem?

[pbaldy]

It sounds like either the form or the combo is locked or the form is read-only.

[Ted C]

It sounds like either the form or the combo is locked or the form is read-only.

The combo box properties are "Enabled=Yes" and "Locked=No".
The form shouldn't be read-only. I don't see any form properties that indicating that it is.

[pbaldy]

What is the Allow Edits property of the form?

[Ted C]

What is the Allow Edits property of the form?

Allow Edits = Yes

[pbaldy]

Can you post the db here?

[Ted C]

Can you post the db here?

hrm... tricky

a) it's a split database
b) it contains employee information that I wouldn't be comfortable sharing

I'll see about making a duplicate and scrubbing the data.

[Ted C]

I attempted to upload scrubbed versions of the database files...

Upload Errors
Training.accdb:
Invalid File
Training_be.accdb:
Invalid File


The upload routine apparently doesn't allow .accdb files.

[pbaldy]

Your instincts are good; we definitely don't want any personal data posted. If you can carve out that form and whatever table(s) it depends on, with no personal data, that should be enough. It's just sometimes easier to figure out a problem when you can put your hands on it.

[pbaldy]

I think the file has to be zipped.

[Ted C]

I think the file has to be zipped.

You are correct, I see.

[Ted C]

"Mass Enrollment" is the form I've been working on.

[pbaldy]

Ah; the problem is you're trying to edit an autonumber field. On my PC I actually get a message to that effect in the lower left corner of the form.

[Ted C]

Ah; the problem is you're trying to edit an autonumber field. On my PC I actually get a message to that effect in the lower left corner of the form.

Hmmm... I don't want to modify it, I just want to select it. I'm guessing I should point it at some other field?

[pbaldy]

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.