Table Names in the combo box

[doran_doran]

Hi,

I am using following to populate tables in the combo box. And IT WORKS.

SELECT DISTINCT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Name) Like "tbl*") AND ((MSysObjects.Type)=1) AND ((MSysObjects.Flags)=0));

However, I would only like to show 4 tables and they are below..
tbl_groups
tblBasicCase
tblPlanContact
tblInvoice.

Is it possible ????

 

[Mile-O]

SELECT MSysObjects.Name AS Tables
FROM MSysObjects
WHERE MSysObjects.Name In ("tbl_groups","tblBasicCase","tblPlanContact","tblInvoice")
ORDER BY MSysObjects.Name;

 

[doran_doran]

Thanks....

Thanks Mile for helping me. I wasn't hopeful. LOL.

 

[Oldsoftboss]

Why not just change the Row Source Type to: Value List, then in the Row Source put: tbl_groups;tblBasicCase;tblPlanContact;tblInvoice.

Dave