Cannot select values in combo box.

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

I have an unbound combobox that displays the results of a
select query. This is the query SQL:

SELECT MsysObjects.Name
FROM MsysObjects
GROUP BY MsysObjects.Name, Left$([Name],1),
MsysObjects.Type
HAVING (((Left$([Name],1))<>"~") AND ((MsysObjects.Type)=-
32768))
ORDER BY MsysObjects.Name;

The query returns a list of the forms in my database. I
have a similiar query for the reports. The query is my
rowsource for the unbound combobox. The combobox will
display the results of the query but will not let you
select any of the results. The box is enabled and is not
locked.
I beleive the fault lies in the query. I experimented and
created another query, a make-table query. I made a table
of the form names and tried to make this the rowsource of
the combobox. It will display the list but again I cannot
select any records.
If anyone can explain why I cannot make this work I would
appreciate it.
 
I found the answer to my own problem. In the properties
box of the form containing the combo box, under the data
tab, Allow Filters/Edits/Deletions/ and Additions had all
been selected to "No". Changing these to "Yes" allowed my
controls to work.
 
Back
Top