[MS_AccessPros] Union query problem

 

I use a union query to populate the row source of a combo box. When the underlying table tblFamilyNames for the first sentence in the query, the query returns no records.

SELECT tblFamilyNames.FamilyNameID,tblFamilyNames.FamilyName FROM tblFamilyNames UNION SELECT "A","<New Family Name>" FROM tblFamilyNames UNION SELECT "B" ,"<Type Family Name>" FROM tblFamilyNames
ORDER BY tblFamilyNames.FamilyName;

I want the combo list to always include <Type Family Name> and <New Family Name> even with tblFamilyNames has no records so that the combo will appear the same when the application is new as it will once tblFamilyNames is populated.

How can I re-word my query to make this happen?

Glenn

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___