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