J
JohnE
Hello. I have a main form (frmClient) with a tab control on it. The main
form is the "one" while the tab control holds the "many". On one tab I have
2 subforms (sfrmAddress, sfrmContact). SfrmAddress is the many to the main
form and the "one" to the second subform (sfrmContact) on the same tab, which
is the "many". The relationships are good and it mainly all works fine. My
question has to do with a combobox on sfrmContact. I would like it to fill
with only information that would be coming from sfrmAddress, which would be
the ID and another cbobox. The sql is as follows;
SELECT tblAddress.AddressID, tblContactType.ContactType
FROM tblAddress
INNER JOIN tblContactType
ON tblAddress.ContactTypeID = tblContactType.ContactTypeID
ORDER BY tblAddress.AddressID
This is were I get stumped. Can anyone see what I need to add?
Thanks in advance for responding.
*** John
form is the "one" while the tab control holds the "many". On one tab I have
2 subforms (sfrmAddress, sfrmContact). SfrmAddress is the many to the main
form and the "one" to the second subform (sfrmContact) on the same tab, which
is the "many". The relationships are good and it mainly all works fine. My
question has to do with a combobox on sfrmContact. I would like it to fill
with only information that would be coming from sfrmAddress, which would be
the ID and another cbobox. The sql is as follows;
SELECT tblAddress.AddressID, tblContactType.ContactType
FROM tblAddress
INNER JOIN tblContactType
ON tblAddress.ContactTypeID = tblContactType.ContactTypeID
ORDER BY tblAddress.AddressID
This is were I get stumped. Can anyone see what I need to add?
Thanks in advance for responding.
*** John