All forms in a Combo Box

[SeRene]

Hi,

I was given the SQL codes as shown below to list ALL the
forms i have in my DB. It is working.. however, I need to
display the form in Datasheet Type and not the tabular
type with a grey background.

Is it something to do with the codes??

Please advise me on this.
Thanks!

SQL Code-->
SELECT MSysObjects.Name AS ObjectName
FROM MSysObjects
GROUP BY MSysObjects.Name, MSysObjects.Type
HAVING (((MSysObjects.Type)=-32768))
ORDER BY MSysObjects.Name;

 

[Arvin Meyer]

In the property sheet of the form, change the Default View property from
Single Form to Datasheet.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[SeRene]

Hi, it's already set to "Datasheet".
When i open it, it's in datasheet format too. It's only
when i made use of a combo box and when i select on the
form in datasheet format, it will appear as a Single Form
type.

 

[Arvin Meyer]

There is nothing wrong with that SQL code. Use it as the recordSource of the
form. Then add a single textbox on the form and set its ControlSource to
ObjectName. Set the forms default view to Datasheet. Works for me.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access