Suddenly unable to select from Combo box dropdown list.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Combo Box on a form that was working fine but has suddenly become
unable to select any values from it's drop down list.
The Enabled and Locked properties of the Combo Box are set to Yes and No.
The Allow Edits property of the form is set to Yes.
I have no idea what else I could have changed that would now be preventing
this.
Any ideas?
 
Tracey,

Any chance you have been playing with the form's recordsource, and ended
up with a nun-updateable recordset as a result (possibly by adding one
more table)? To verify, open directly the query being the form's
recordsource, and see if it accepts changes, or gives you the
non-updateable recordset error message.
Note: if the form's recordsource is not a saved query, copy the SQL
expression from the form's RecordSource proprty, and paste it in a new
query's SQL view (New Query, add no table, select SQL view) to get the
same result.

HTH,
Nikos
 
Related to Nikos's reply.
Another way (and I have done it) is that you may have dropped or
changed the name that is the source field for the dropdown.

All appears well UNTIL you try to select and item from the dropdown and
you get the reaction you described.

Ron
 
Back
Top