Glenn,
I think you only need to change out the "FROM tblFamilyNames" to a table that will always have at least one record.
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: argeedblu@gmail.com
Date: Tue, 18 Mar 2014 11:52:05 -0700
Subject: [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
I think you only need to change out the "FROM tblFamilyNames" to a table that will always have at least one record.
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: argeedblu@gmail.com
Date: Tue, 18 Mar 2014 11:52:05 -0700
Subject: [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 (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar