Hlp! Combo Box Content

D

dee

Hi,

I've got a form and subform:

The main form displays MeetingID, FamilyName combo box that populates
FamilyID, MainPhoneNumber, DateOfMeeting, MeetingNotes.

The sub form displays ContactID which is populated by a combo box that is
SUPPOSED to display only the contact names for the family currently displayed.

I initially had ALL contact names displayed, no matter which family was
currently displayed and, after help here, modified by SQL, but now it shows
only the first contact name for ALL families. So, I have a particular name,
say John Smith - Father displayed no matter what!

Here is my SQL combo box code:

SELECT QryConcatenatedContactNames.ContactID,
QryConcatenatedContactNames.ContactName, QryConcatenatedContactNames.Role,
QryConcatenatedContactNames.FamilyID
FROM QryConcatenatedContactNames
WHERE
(((QryConcatenatedContactNames.FamilyID)=[Forms]![FrmFamilyMeetings]![FamilyID]))
ORDER BY QryConcatenatedContactNames.ContactName;

I would appreciate any help. I'm spending days on this and am getting very
frustrated! :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subform duplication records 5
Child/Master Links 8
Complicated Sub-Form Questions 0
PLEASE HLP - SubForm 8
Combo box search from main form to subform 1
Combo Box Stops Working after Passing Data from Another Form 1
Restrict Combo Box Content 8
Combo Box Problem 5

Top