Cannot select values in combo box.

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.
 
R

Rob

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top