Here are the applicable portions of my database design –
tblMembers.MemberID (Primary Key)
tblMembers.AddressID (foreign Key – Addresses table)
tblMembers.FirstName
tblMembers.LastName
tblMembers.SponsorID
tblAddresses.AddressID (Primary Key)
queryMembersAddressIDs.MemberID (from tblMembers)
queryMembersAddressIDs.AddressID (from tblAddresses)
queryMembersAddressIDs.FullName (which is - [tblMembers].[LastName] & “, “ & [tblMembers].[FirstName] )
I am trying to setup a combo-box field on a form that will allow me to use the auto-expand feature. I want to use the auto-expand feature so I can type the members name (as shown in qryMembersAddressIDs.FullName), and then store that members AddressID in the tblMembers.SponsorID field.
I thought one way to do it would be to make 2 combo-box fields on the form, one with the member’s full name (for the lookup) and another with the members AddressID (to store in the tblMembers.SponsorID field). I thought there would be a way to link the two combo-boxes. I found a lot of information about linking cascading combo-boxes, but I don’t need cascading combo-boxes.
How do I do this?
tblMembers.MemberID (Primary Key)
tblMembers.AddressID (foreign Key – Addresses table)
tblMembers.FirstName
tblMembers.LastName
tblMembers.SponsorID
tblAddresses.AddressID (Primary Key)
queryMembersAddressIDs.MemberID (from tblMembers)
queryMembersAddressIDs.AddressID (from tblAddresses)
queryMembersAddressIDs.FullName (which is - [tblMembers].[LastName] & “, “ & [tblMembers].[FirstName] )
I am trying to setup a combo-box field on a form that will allow me to use the auto-expand feature. I want to use the auto-expand feature so I can type the members name (as shown in qryMembersAddressIDs.FullName), and then store that members AddressID in the tblMembers.SponsorID field.
I thought one way to do it would be to make 2 combo-box fields on the form, one with the member’s full name (for the lookup) and another with the members AddressID (to store in the tblMembers.SponsorID field). I thought there would be a way to link the two combo-boxes. I found a lot of information about linking cascading combo-boxes, but I don’t need cascading combo-boxes.
How do I do this?