Can Anybody Help Me Out ??? (1 Viewer)

[vtrm]

I HAVE A DB WITH SOME FORMS. I WANT TO POPULATE A COMBOBOX WITH THE NAMES OF THESE FORMS. HOW CAN I DO IT??

 

[Pat Hartman]

You might start by turning off the caps lock key.

The MSysObjects table contains a list of all objects in your database. You can use a query of this to populate the combo. The following will return a list of just the forms.

SELECT MSysObjects.[Name]
FROM MSysObjects
WHERE MSysObjects.[Type] = -32768
ORDER BY MSysObjects.[Name];

 

[vtrm]

Populating Listbox

THANKS PAT.
TO GO JUST A BIT FURTHER, WHAT SHOULD I DO IF I NEED THE "TAG" PROPERTY (NOT THE NAMES) OF THESE FORMS TO BE POPULATED INTO THE LISTBOX? IS THERE A WAY OUT??

 

[Pat Hartman]

You didn't turn off your caps lock button. I have no idea what the tag property of a form is.

 

[vtrm]

Open a Form and go to its properties - "Other" - You will find the Tag property.

Caps off !!